It's better to have it and not need it then...

[Guest]

....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.

 

[Bob Phillips]

IF(B1<>"",B1,0)

and format as #,##0.00

--

HTH

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

 

[Guest]

Thanks Bob

IF(B1<>"",B1,0)

and format as #,##0.00

--

HTH

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

 

[Gord Dibben]

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