ExcelBanter - Formula help please

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula help please (https://www.excelbanter.com/excel-programming/271407-re-formula-help-please.html)

Tom Ogilvy

Formula help please

=if(c26="yes",c27*b22,0)

Regards,
Tom Ogilvy

"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

All times are GMT +1. The time now is 10:55 AM.