Thank you for all the help everyone in this forum has provided thus far! I truly appreciate it! I have this formula which is not working the way I need it to...

=IF(ISBLANK(C5),"",IF(C5>=1,100-F5,0))

This part specifically

100-F5The 100 is suppose to represent 100% and the value in F5 is a %. I keep getting 9930%. The value in F is 70%.

TY!

I think this may work =IF(ISBLANK(C5),"",IF(C5>=1,100-F5*100,0))this should return 30 if I am correct?

message edited by AlwaysWillingToLearn

If the value in F5 is formatted to display 70% and the cell with the formula is formatted the same way, I believe that this will get you what you want: =IF(ISBLANK(C5),"",IF(C5>=1,100%-F5,0))

This should return a Blank cell or 30% or 0%

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Thank you for your help. I actually place () around 100 without the % and it worked like a charm!

FWIW, that makes absolutely no sense. With 70% in F5, and the cell containing the formula formatted as a percentage, both of these formulas return 9930%

=IF(ISBLANK(C5),"",IF(C5>=1,100-F5,0))

=IF(ISBLANK(C5),"",IF(C5>=1,(100)-F5,0))

This formula returns 30%

=IF(ISBLANK(C5),"",IF(C5>=1,100%-F5,0))

I can't think of any scenario where placing () around a single hardcoded number will change the result of the formula. Parentheses control the order of operation of the formula. Placing parentheses around a single hardcoded number does nothing to change the order of operation.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

You are correct! I compared the formula I pasted into my initial question earlier today vs. the formula I ended up with after I continued to play with the formula while I waited for an answer and again, you are correct, if I () 100 it did not work. Thank you again!

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History