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.

Simple function or formula I think
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Hard disk diagram simple - Guide
Number to words in excel formula - Guide
Agp function - Guide

1 response

Answer 1 / 1

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!