What is "previous" cell.

Above or left?

=IF(A1="",0,A1)

Enter in A2 or B1 depending upon answer to above.

Format to two decimal places or currency.


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 06:57:01 -0700, "dvonj"
wrote:

...To need it and not have it.
I think I saw this a while ago but didn't need it at the time, now I could
use it. I have a column called Rate/Hours. To show what rate is being
charged. I need the column to base the rate on the previous cell. If there is
data in the previous cell then display the rate, if there is no data in the
previous cell then display "0.00" as the rate.
How could I have been so blind.