Formula Question

[MHowie]

Hi,

If anyone can help with this one I'd be grateful.

I'm trying to make a formula for this situation -

If cells A1 or B1 are empty then C1 should not display anything at all.

If they aren't empty then C1 = 400-A1+B1

Thanks very much if you can help!

Mark

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(OR(A1="",B1=""),"",400-A1+B1)

 

[Peter_SSs]

Welcome to the MrExcel board!

Try

=IF(COUNT(A1:B1)=2,400-A1+B1,"")

 

[MHowie]

Thank you very much Fluff and Peter!

 

[Fluff]

Glad we could help & thanks for the feedback.