Second Logical test in if statement

heres what I have

=IF(S!A7="","",S!A7)


In addition the the formula returning "" when s!a7 is blank, I would also like it to return "" if the cell contains "-".

I believe what i need is a nested if, or an and operator, but im not familiar with those types of formulas.

Thanks for your help!

Hello speakers_86,

Use the OR operator...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

thanks ron!