Excel 2002 Formula

[Joanne Nakaya]

I need to create a formula in one cell that will display
the answer in a different cell. The formula is in C6 and
is: if the value in C5 is greater than zero, then
display the value (that is in C5) in cell D5, otherwise
display zero.

Thanks,

Joanne

 

[Biff]

Hi Joanne!

You can't do it that way. A formula cannot "assign" a
value to any cell other than the one it's in. What you can
do is this, in cell D5 enter one of these formulas:

=MAX(C5,0)

or

=IF(C5>0,C5,0)

Biff

 

[JE McGimpsey]

Worksheet formulas can only return values to their calling cells - they
can't put values in other cells.

Instead, in D5 put

=IF(C5>0,C5,0)

or, more succinctly:

=MAX(0,C5)