Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |