Calculation Help

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

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
 
Joel said:
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
Click to expand...

You should not have an exclamation mark after R29 near the end of your
formula.
 
Hi Joel

In your value if false argument, try removing the final ! after the R29 cell
reference. This should then be OK
 
Look closely at the end of the formula

from
=IF(Template!R29="","",(H5-Template!R29!))
to
=IF(Template!R29="","",(H5-Template!R29))
 
Perhaps you have non-numeric values either in Template!R29 or H5. What is the
error message, and what is the content of these cells?

Regards,
Stefi

„Joel†ezt írta:
 
IF(Template!R29="","",(H5-Template!R29!))
to
IF(Template!R29="","",H5-Template!R29)
 
Back
Top