Have the following forumla;

=IF(AND(A2="C/FWD",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: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=539203

Hi ExcelBob,

Your requirements aren't clear.

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

Cheers

"ExcelBob" wrote in
message ...

Have the following forumla;

=IF(AND(A2="C/FWD",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:
http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=539203

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

Many Thanks!!!!


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=539203