Formula help
 

I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)

Formula help
 

=IF(OR(C21="DOG",C21="CAT"),E21+F21,0)

"Peter" wrote:

I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)

Formula help
 

Or do you mean this
=IF(C21="DOG",E21+F21,IF(C21="CAT","Zero",0))

"Peter" wrote:

I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)

Formula help
 

"Peter" wrote in message
...
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.
--
Rich
http://www.richdavies.com/jingle-smells.htm
http://www.richdavies.com/excel.htm


** Posted from http://www.teranews.com **

Formula help
 

I think he probably meant
=IF(C21="dog",F21+G21,IF(C21="cat",0,""))
--
David Biddulph

"Mike" wrote in message
...
Or do you mean this
=IF(C21="DOG",E21+F21,IF(C21="CAT","Zero",0))

"Peter" wrote:

I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0)