| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
#VALUE! Error
in cell E8 I have this formula: =IF(ISBLANK(D8),"",D8*$B$2)
I get the #VALUE! error. Can someone tell me why and how I can correct it. I am just trying to say that if D8 is empty don't show anything, if populated multiply D8 by B2. Thank you for your help -- Diana |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
Threaded Mode
