Help with simple "if,then" formula (I think it may be simple)

[islandeeya]

Hi everyone,

I am trying to create an "if,then" formula that shows:

if cell E8 is greater than 171, then i'd like cell E9 to show the value of cell in E8.

Thank you all for your help!

[tapsmiled]

Put this in E9:

=IF(E8>171,E8,"")

It will leave a blank space if the amount is less than 171.

[islandeeya]

Thank you very much for you answer. i have out in the formula and the words "true" are displayed.

what i'm trying to do is in E9, if E8 is less than 171, i would like a zero or nothing, if E8 is more than 171, i would like E9 to show the difference of 171 and the number in E8.

i think i didn't word it correctly in the beginning.

[kspeese]

The formula you were provided should do exactly what you asked except if the number is 171, it would still be blank.

Please Login or Register  to view this content.

Looking at the below formula, now I understand what you were saying.

[tapsmiled]

=if(E8<171,"",E8-171)

[islandeeya]

Thank you all for your wonderful help!! Tapsmiled your first suggestion of: =IF(E8<171,"",E8-171)works!!

can i say i luv you!!

[tapsmiled]

You can......and you can also mark this as SOLVED (at the top under Thread Tools). Glad I could help!!