Calculation Help
 

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

Calculation Help
 

"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
--


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

Calculation Help
 

Hi Joel

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

"Joel" wrote:

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

Calculation Help
 

Look closely at the end of the formula

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


"Joel" wrote:

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

Calculation Help
 

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:

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

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