View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris LeBlanc Chris LeBlanc is offline
external usenet poster
 
Posts: 1
Default Formula help please

=IF(C26="yes",(C27*B22),0)

Chris


"scott" wrote in 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