Simple function or formula I think [Solved/Closed]

Report
-
Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
-
Hello,
I want to set up a formula or function to display a number from another cell only if a different cell is greater then 0. Example: data in Cell A1 to show in C1 ONLY if data in C2 changes to greater then 0. Help please? I am using Excel 2003.

1 reply

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
475
Hi,
According to your example, you have to put in cell C1, the following formula :
=IF(C2>0,A1,"")
Best regards

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!