Hi Everyone
I am having a problem with a simple formula ... it doesn't get auto updated.. it calculates the value when i write the formula and press enter.. but when i change the value of a linked variable it doesn't get updated..
the cell is set to automatic calculations..
Formula looks like.. : =((B22+C19)/(C15*C18))*C18
But what i realized is that if take the last part out of the formula and write it as below.. it works fine.. and auto updates..
=((B22+C19)/(C15*C18))
Any ideas?
C18 is what i want to keep as a variable and change..
I am able to send the excel file if anyone will like to have look at it..
Excel version 2010
C18 cancels out and does not affect your result at all. If you're changing the value in C18, nothing will happen. Does the value change if you change B22, C19 or C15?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks