Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help please
It is quite easy, you just need quotes around the yes so
that it knows that it is text. =if(c26="yes",c27*b22,0) Hope this helps, Helen -----Original Message----- Hi this is an easy one but can't quite remember how to make it work. I want the formula to calculate: if c26=yes, then c27 * b22, if not,0 I tried this and it didn't work =if(c26=yes,c27*b22,0) I got a #name result Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|