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

"Joel" <(E-Mail Removed)> wrote in message
news:BBC7D3D6-83AB-4EEF-8F27-(E-Mail Removed)...
> 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.

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

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

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

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Joel" <(E-Mail Removed)> wrote in message
news:BBC7D3D6-83AB-4EEF-8F27-(E-Mail Removed)...
> 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