Help

[kebba31]

What's the formula I need to enter if I want a figure to appear in one cell but only if another cell is greater than 0. i.e. If D20 is > than 0 then N20=$4?

 

[Jonmo1]

Welcome to the board...

Try

=IF(D20>0,4,"")

 

[kebba31]

Excellent!!! That worked. This site is awesome and saved me a lot of time trying to figure it out. Thanks.

 

[dcofer]

Hello kebba31,

Welcome to the Board.

Are you wanting the result in cell N20? If so, then place this formula in N20:
=IF(D20>0,"$4","")

This formula assumes the value you want in N20 will always be $4 formated as such if D20 is greater than zero.

Hope this helped.

Regards,

David

 

[kebba31]

Thanks again for your help.
I know have another situation, now that I entered the formula above in cell N20 another cell Q20 which adds a few columns together in row 20 (including cell N20) is reading #value!. How do I fix this? The formula in cell Q20 currently reads: =sum(J20+L20+N20+020)

 

[Jonmo1]

Change
=IF(D20>0,4,"")
to
=IF(D20>0,4,0)

 

[kebba31]

Awesome! You all rock!!! Thanks again.