| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value Being Returned for Blank or Non Zero Value
Appreciate the feed-back.
Most folks leave the responders hanging.<g -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Jack" wrote in message ... "Ragdyer" wrote in message ... What's in G40 and F39? You say they're *both blank*, but F39 is returning a #Value! error! How can it be *both ways*? Do they contain formulas? A #Value! error can come from a formula performing calcs on a cell containing text. -- Regards, RD G40 is my the tax rate of 7.375% and F39 is =IF(SUM(F18:F38)0,SUM(F18:F38),"") What I am doing is multiply my tax rate times the subtotal. If the spreadsheet is blank without any values, then it WAS returning a #value! error message. I have since cleaned up the formula in cell F40 with this formula: =IF(ISERROR(F39*G40),"",(F39*G40)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make #N/A blank if no value is returned | Excel Worksheet Functions | |||
| #N/A value is returned | Excel Worksheet Functions | |||
| #NUM! being returned instead of 0 or blank | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
| blank cell returned | Excel Worksheet Functions | |||
Threaded Mode
