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))

One way ..
Try adding a zero to coerce the text numbers in col G to real numbers:
=IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3+0 ,(G3+0)/$E$3),2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AD108" wrote:
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))

THanks, I'll try that.
"Max" wrote in message
...
One way ..
Try adding a zero to coerce the text numbers in col G to real numbers:
=IF(ISBLANK(G3),"",ROUND(IF(OR(H3="cs",H3=""),G3+0 ,(G3+0)/$E$3),2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AD108" wrote:
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))

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AD108" wrote:
THanks, I'll try that.

I tried that, but it's still doing the same thing. If I select the cell,
press F2 and then enter, the error goes away. I tried reformatting them
also. Weird.

Maybe I'll just use some code to convert the cells to numbers.

"Max" wrote in message
...
You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AD108" wrote:
THanks, I'll try that.

"AD108" wrote:
I tried that, but it's still doing the same thing. If I select the cell,
press F2 and then enter, the error goes away. I tried reformatting them
also. Weird.

Wondering whether calc mode has anything to do with it? Could it be
inadvertently set to Manual? Press F9, does it now compute? Check and ensure
calc mode's on Automatic via: Tools Options Calculation tab
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---