OR IF Formula?

[WarriorJ23]

Hello all,

I have an excel spreadsheet that evaluates weights entered in a column to determine if they are above or below the specification. Column C contains the reference value, column E contains the actual weight data and column F contains the evaluator.
Here is the current formula used in column F: =IF(E5<C5, "LT", "")

This formula works great except that when there is no data in column E the default value of column F is "LT"
I would like a formula that leaves column F blank if column E doesn't have any data. It seems like it ought to be simple, I just haven't been able to figure it out yet.

Thanks in advance!

[Brendan_Floyde]

nested if

Please Login or Register  to view this content.

[WarriorJ23]

Thank you! That works great! Could you explain the necessity for the empty double quotes?

[Brendan_Floyde]

You can do with out - I tend to include as a blank cell can be interpreted as a zero by excel in some circumstances and I just think lots of zero's is a mess. "" is interpreted as text but of no length.

I also think it makes the function a bit easier to read.

[WarriorJ23]

Makes sense. Thanks for the help!

[Brendan_Floyde]

you seem to be sorted so please can you mark the thread solved?

-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

[WarriorJ23]

Done. Thanks again for your help!