IF AND OR Worksheet Functions

E

ExcelBob

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
 
M

macropod

Hi ExcelBob,

Your requirements aren't clear.

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

Cheers
 
Top