IF(B1<"",B1,0)

and format as #,##0.00

--

HTH

RP
(remove nothere from the email address if mailing direct)


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