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
.