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

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.

Thanks Bob

"Bob Phillips" wrote:

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.

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.