Simple function or formula I think

Solved/Closed
Dan - Aug 30, 2009 at 10:11 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Sep 2, 2009 at 04:45 PM
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 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Sep 2, 2009 at 04:45 PM
Hi,
According to your example, you have to put in cell C1, the following formula :
=IF(C2>0,A1,"")
Best regards
0