need help with IF statement

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate blanks while copy row and transpose 11
Calculating time without using military time 4
conditional format -- if not a date, then highlight cell 1
Can Vba workout if a selection is part of a group? 0
Excel Excel 2003 "If" function 1
VBA help for simulation 1
Help with a nested IF statement 6
VBA help 5

Back
Top