Excel help Please!! If formulas

August 20, 2011 at 19:02:01
Specs: Windows XP
Hi guys, I am trying to find out how to return a value of a cell if another cell is filled, if you could help me I really appreciate

e.g - I will try and build the cenario

What I am trying to do is - A1 is empty, but if A1 is filled with the word SOLD than I would like A5 to be the value of A2 . Does that make sense to anyone of you who could help? Below is what I would like to do.

A1 A2 A3 A4 A5
empty 2 x y 0

A1 A2 A3 A4 A5
SOLD 2 x y 2

Thank you

See More: Excel help Please!! If formulas

Report •

August 22, 2011 at 07:49:34
First, a posting tip...

Please click on the blue sentence at the end of this post and read the instructions on how to post data in this forum. Following those instructions when posting data will make it much easier for us to understand the layout of your spreadsheet.

As for your question, you should review the Excel Help file for the IF function. Your question appears to be a fairly straightforward use of a basic IF statement.

You should read the Help file so that you understand the following suggestion and can adapt it to other situations.

Try this in A5:

=IF(A1="SOLD", A2, 0)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question