If then else....
 

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

If then else....
 

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

--
HTH

Bob Phillips

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

"Susanne" wrote in message
...
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

If then else....
 

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

"Susanne" wrote:

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