=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)


"Ms Trish" <Ms wrote in message
...
Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met. How can I have
the
word "false" submerged.