I need a Formula to show AF4 if >0, if zero or <0 then will remain blank?

[Mr.Castle]

I need a Formula to show AF4 if >0, if zero or <0 then will remain blank?

[Joske920]

Hi Mr.Castle,

is there a formula in the cell or does it hold data?

if formula in the cell
=IF("formula">0;"formula";"")

if there is just data you could go the condition format way and make the font same color as the background

Grtz

[jtakw]

Hi,

Do you mean show the Value in Cell AF4?

=IF(A1>0,AF4,"")

Or if you mean the Text AF4?, if so, change AF4 in formula to "AF4"

[Mr.Castle]

jtakew the formula =IF(A1>0,AF4,"") worked

Thanks.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[rwat1]

Please Login or Register  to view this content.

[jtakw]

Please Login or Register  to view this content.

See Post # 3.