View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Telegirl Telegirl is offline
external usenet poster
 
Posts: 4
Default If Statement Not Working

Several people have worked on this and I am sure it is something obvious, but
the following If Statement will not work:

=IF(SUM(I14:I19)=(G20-H20),(G20-H20),"error")

It always returns 'error', even if the statement is true. Any suggestions?

Thanks a lot!