| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation | Excel Discussion (Misc queries) | |||
| Age calculation | Excel Discussion (Misc queries) | |||
| Calculation --- What's going on? | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
