ExcelBanter - need help with IF statement

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

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

- - need help with IF statement (https://www.excelbanter.com/excel-programming/306454-need-help-if-statement.html)

Scott

need help with IF statement

I have a cell that calculates C10 * 4

If C10 is blank I want the cell to be 0 but right now its
saying #VALUE!

How can I change this so if the C10 is blank the cell I
am calculating says 0 else it calculates the c10* 4

thanks!
scott

Tom Ogilvy

need help with IF statement

=if(C10="",0,C10*4)

--
Regards,
Tom Ogilvy

"scott" wrote in message
...
I have a cell that calculates C10 * 4

If C10 is blank I want the cell to be 0 but right now its
saying #VALUE!

How can I change this so if the C10 is blank the cell I
am calculating says 0 else it calculates the c10* 4

thanks!
scott

All times are GMT +1. The time now is 09:18 PM.