Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |||
Standard Error Bars. | Excel Discussion (Misc queries) | |||
Strange error with basic divide function | Excel Worksheet Functions | |||
I am getting a strange round off error in excel | Excel Worksheet Functions | |||
strange error on saving | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |