software

Have the following forumla;

=IF(AND(A2=quot;C/FWDquot;,A3=1),A3,0)

but also want to return the value in A3 if A3 = 2, 3, 4, 5 etc....

Any ideas?

Thanks--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: www.excelforum.com/member.php...oamp;userid=34152
View this thread: www.excelforum.com/showthread...hreadid=539203Hi ExcelBob,

Your requirements aren't clear.

If they've all got to return the same result, how about:
=IF(AND(A2=quot;C/FWDquot;,A3gt;0),A3,0)
or, if A3 is has to be an integer:
=IF(AND(A2=quot;C/FWDquot;,A3=INT(A3)),A3,0)

Cheers

quot;ExcelBobquot; gt; wrote in
message ...
gt;
gt; Have the following forumla;
gt;
gt; =IF(AND(A2=quot;C/FWDquot;,A3=1),A3,0)
gt;
gt; but also want to return the value in A3 if A3 = 2, 3, 4, 5 etc....
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; ExcelBob
gt; ------------------------------------------------------------------------
gt; ExcelBob's Profile:
www.excelforum.com/member.php...oamp;userid=34152
gt; View this thread: www.excelforum.com/showthread...hreadid=539203
gt;

Macropod!! - quite easy when you think about it.

Many Thanks!!!!--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: www.excelforum.com/member.php...oamp;userid=34152
View this thread: www.excelforum.com/showthread...hreadid=539203