View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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