P
Peter
I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)
If(c21=dog then f21+g21) or if (c21=cat then 0,0)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
=IF(OR(C21="DOG",C21="CAT"),E21+F21,0)
M
Mike
Or do you mean this
=IF(C21="DOG",E21+F21,IF(C21="CAT","Zero",0))
=IF(C21="DOG",E21+F21,IF(C21="CAT","Zero",0))
R
Rich
Peter said:I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)
=IF(C21="dog",(F21+G21),0)
cat or anything else will be zero.
D
David Biddulph
I think he probably meant
=IF(C21="dog",F21+G21,IF(C21="cat",0,""))
=IF(C21="dog",F21+G21,IF(C21="cat",0,""))