Formula for markup won't change when the initial value is changed.

G

Guest

[in cell k16]J16*20% [in cell L16] SUM(J16+K16)

When I change the value in j16 it the values in K and L remain unchanged???
I've used this simple formula for over 10 years w/o a problem. It seems like
excel has change the way it is recalculating (or not) the formula.
Steve in Eugene
 
R

Roger Govier

Hi Steve

Maybe Tools>Options>Calcualtion and select Automatic.
It sounds as though it has been switched to Manual.
Excel foolows the rule for calcualtion as found in the first workbook opened
during that session.

Regards

Roger Govier
 
G

Guest

Thank you.
Someone used my computer and changed the method to manual,
Thank You Peo,

Steve

Peo Sjoblom said:
Tools>options>calculation and make sure it is set to automatic

--

Regards,

Peo Sjoblom


Steve in Eugene said:
[in cell k16]J16*20% [in cell L16] SUM(J16+K16)

When I change the value in j16 it the values in K and L remain unchanged???
I've used this simple formula for over 10 years w/o a problem. It seems like
excel has change the way it is recalculating (or not) the formula.
Steve in Eugene
Click to expand...
Click to expand...
 

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

formula question 1
Scrabble Value calculation for Welsh words 0
Help ! How do I do this in VB Script 3
Vlookup for a max value ? 4
Searching the formula (not the value) for a text string 1
Is there a way to change the color 3
How to keep formula and be able to input value in cell? 0
formula won't change correctly when dragged 4

Top