Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't want !ref displayed when source worksheet has not data.
I have a formula the multiplies two cells and adds that product to a
referenced cell from another worksheet. For example: =T9*L14+GETPIVOTDATA("Billing Amount",'Labor Pivot'!$A$6,"TradeCode","F04") The problem is that when the Pivot Table is changed, the data that the formula is looking for may not be there anymore and the formula cell displays #REF!. Is there a way for my formula to still display the product of T9*L14 and if no data can be found from the Pivot Table it ignores that part of the formula or equates it to 0? Thanks, Ryan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't want !ref displayed when source worksheet has not data.
You could try ands check for the error with an if staement perhaps.
something like: =IF(ISERR(your formula here),T9*L14,put your formula here) It should calculate your formula and if the result is going to be #REF it will multiply your two cells only and show that. If it is not an error then it will show the full calculation. Does that make sense? " wrote: I have a formula the multiplies two cells and adds that product to a referenced cell from another worksheet. For example: =T9*L14+GETPIVOTDATA("Billing Amount",'Labor Pivot'!$A$6,"TradeCode","F04") The problem is that when the Pivot Table is changed, the data that the formula is looking for may not be there anymore and the formula cell displays #REF!. Is there a way for my formula to still display the product of T9*L14 and if no data can be found from the Pivot Table it ignores that part of the formula or equates it to 0? Thanks, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste a chart and get the source data to be from the new worksheet | Charts and Charting in Excel | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions |