Error in formula

A

AD108

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,G3/$E$3),2))
 
N

Norman Jones

Hi AD108,

Is tha calculation method being set to manual? Try explicitly setting
calculation to xlAutomatic.
 
A

AD108

Thanks,

Something strange happened to my outlook, and I thought the original post
may have been lost. I'll try that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to avoid error? 1
Complex If/Or/And formula 7
Need cell value not cell pointer returned from formula 2
strange error 7
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Copy/paste in based on duplicate value in previous row 0
MAX value but with two comparison filtering criteria 5
Copy addition formula of non-consecutive horizontal cells 2

Top