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