View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Calculation Help

IF(Template!R29="","",(H5-Template!R29!))
to
IF(Template!R29="","",H5-Template!R29)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joel" wrote in message
...
Hi can someone please help I am trying to calculate a cell but it
references
to to a number of different sheets.

=IF(Template!R29="","",(H5-Template!R29!))

I keep getting an error message about the the fact that the calculation is
missing something.

Regards Joel

and thanks
--
N/A