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

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History