"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 **