Simple function or formula I think [Solved/Closed]

Question

Simple function or formula I think [Solved/Closed]

Report

Dan - Aug 30, 2009 at 10:11 PM
aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

- 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
Functions and formula of the electronic spreadsheet - Articles
The simple Excel formulas (calculation VAT inclusive) - How-To - Excel
Excel (all versions) - How to copy a simple formula? - How-To - Excel
Which of the following functions can be used to minimize the number of if statements in a formula - How-To - Excel
Formula Question: "IF" function with date ✓ - Forum - Excel

1 reply

Ask a question

aquarelle · Answer 1 · 2009-09-02T16:45:03-0400

Answer 1 / 1

aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

475
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

Simple function or formula I think [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!