Formulas not behaving?

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

A spread sheet formula using IF statements that has
worked for some time is all of a sudden not calculating
correctly. I have evaluated the formula and it is
written correctly.

IF(I9>0,I9*.1,0)+IF(I10>0,I10*.075,0) This formula works
fine in the original cell, but now when I copy it to
other cells, rather than re-input, it calculates wrong,
giving me the result from the cell of origin? Is there a
function somewhere that I am missing that replicates the
formulas this way, or maybe I am not holding my mouth
right????
Help this has to be done today!
Thanks
Jackie
 
Are you trying to use I9 and I10 again?

Two ways:

1) convert the references to absolute (see "the difference between
relative and absolute references" in XL Help):

=MAX($I$9 * 0.1,0) + MAX($I$10 * 0.075,0)

or, 2) keep the old formula, and enter edit mode in the new cell before
pasting.
 
Jackie

Sounds like calculation mode is "manual".

Check Tools>Options>Calculation.

Change to "automatic"

Gord Dibben Excel MVP
 
Thanks Gord; that did the trick, now how on earth did the
manual flag switch on? I was not even aware of the manual
flag?
Thanks again
Jackie
 
Jackie

If you're wondering how it got switched to "manual"......

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>

Gord Dibben Excel MVP
 
Back
Top