If then else....

S

Susanne

Question...
How do I write a formula in cell A1 to make this happen:
If the cell A5 is blank or "0" I need Excel to return the value of cell B7.
Otherwise it should be the value og A5.

I know how to restrict making sure that the cell is never empty - if that
makes it easyere..

Please can anyone help me?

rgs Susanne
 
B

Bob Phillips

=IF(OR(a5="",A5=0),B7,A5)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top