| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
I need the correct formula for the following propblem...
If(c21=dog then f21+g21) or if (c21=cat then 0,0) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ** |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
