Thread: IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phuser
 
Posts: n/a
Default IF Statement



=IF(SUM(G7-M7)0,SUM(G7-M7)," ")

I love how this keeps the cells clean BUT because there is no value in the
cell, I cant calculate any further,
all I get in return is a #Value
Is it possible to use 2 or more cells like this in a calulation? and if so
what syntax would I use?