Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid error?
I have the following formula in column "I". I have code that puts a range
of values in to column "G". The values must be pasted as "Values" as the source range contains formulas. When the values are pasted, all the formulas in "I" return an error. The weird thing is, if I double click any of the cells in "G" and press enter, the error goes away. Any suggestions on how to fix this? =IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3,G 3/$E$3),2)) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid error?
Hi AD108,
It is unnecessary to open multiple threads for the same question. One possible reason for the paucity of response may be that you failed to show the problematic code. That said, see your original post for one guess. --- Regards, Norman "AD108" wrote in message ... I have the following formula in column "I". I have code that puts a range of values in to column "G". The values must be pasted as "Values" as the source range contains formulas. When the values are pasted, all the formulas in "I" return an error. The weird thing is, if I double click any of the cells in "G" and press enter, the error goes away. Any suggestions on how to fix this? =IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3,G 3/$E$3),2)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to avoid zero error in log log plot | Charts and Charting in Excel | |||
UDF/VBA Function, trap error, avoid #VALUE! | Excel Programming | |||
How to avoid an error dialog | Excel Programming | |||
Avoid error with simple subtraction function | Excel Programming | |||
How to avoid error 2015 when using ActiveCell.Offsett in own function | Excel Programming |