Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#VALUE! issue
Is there a way to avoid a #VALUE! error being returned where there is no
value to return? The formula I am using is simple =E33-J33 however J33 contains a formula and in this particular instance does not return a value, so the error I am getting stems from here. Anyone know of a solution? Many thanks for any suggestions. Pat |
#2
|
|||
|
|||
One way ..
Try: =IF(ISERROR(J33),"",E33-J33) -- Rgds Max xl 97 -- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom --- "Pat" wrote in message ... Is there a way to avoid a #VALUE! error being returned where there is no value to return? The formula I am using is simple =E33-J33 however J33 contains a formula and in this particular instance does not return a value, so the error I am getting stems from here. Anyone know of a solution? Many thanks for any suggestions. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Network issue | Excel Discussion (Misc queries) | |||
Issue with copying Text. | Excel Discussion (Misc queries) | |||
Autofill issue... | Excel Discussion (Misc queries) | |||
addin loading issue | Excel Discussion (Misc queries) |