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