View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Stuck on Blanks
 
Posts: n/a
Default Blanks as a condition of a statement

How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1:
IF b1 is not blank then add b1-c1 else don't do anything in
a1.
I have tried but can't get anything to go.
Thanks in advance,
Lee