Simple function or formula I think [Solved/Closed]

Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
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
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
486
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!