| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value Being Returned for Blank or Non Zero Value
I am referring to a cell in my spreadsheet that currently has no value
associated to it. I have a formula in the cell that refers back to another cell. For example in cell F40 there is a calculation of =H40. In cell H40 I have =G40*F39. G40 and F39 are both blank. When I enter data into the spreadsheet these cells will then be populated/calculate from the previously entered data. Cell F39 is returning #VALUE. Is there a way for me to have this field return a blank, if the value it's referring to is zero or blank? |
| 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
