Calculation Help

[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

 

[Stephen]

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

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

 

[Nigel]

Hi Joel

In your value if false argument, try removing the final ! after the R29 cell
reference. This should then be OK

 

[Joel]

Look closely at the end of the formula

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

 

[Stefi]

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:

 

[Don Guillett]

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