Excel 2010 - IF and ISBLANK formula help needed

[sjp0362]

Having problems figuring out my IF formula.

If the value in cell F4 = "???" or if F4 is empty, I want to "LS", else I want the value that is in F4 to be returned.

Believe I need to use the ISBLANK formula for F4 being empty, but can't seem to get the right formula put together.

 

[mintjulep]

=IF(OR(F4="???",ISBLANK(F4)),"LS",F4)

 

[sjp0362]

Thanks, that's what I thought the formula should be, but originally I wasn't getting anything when cell F4 "looked" blank. Found out my cell actually contained a space and wasn't actually blank. Your confirming my formula finally helped me to see that. Thank you very much

 

[SkipVought]

"looked" blank

Some spreadsheet users have a very bad habbit of using the SPACE bar rather than the DELETE key.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lionelhill]

You can always substitute TRIM(F4) for all instances of F4 in order to remove all "excess" spaces, if this is appropriate to your application.

 

[sjp0362]

Some of the information on my spreadsheet is actually export data out of our estimating program. We're needing to convert some information (which I'm doing through numerous formulas in Excel) in order to import into our accounting program.