incremental addition or subtraction

L

Legacy 23340

Guest
I have a few cells with relevant values and here is a small explanation of what I want to do.

I have master cells j2 and k2.

I also have values in cells h15 and h16 then j15 and j16 but these are rough values sometimes very far apart i.e h15 far apart from h16 and j15 far apart from j16.

i also have the increment that i would add or subtract in m2.

If i type add in l2, add increment in m2 to value in k2 until i get a closely calibrated figure as close to the figure in h16 as possible, then the same for h15 in another cell.

if i type subtract in l2 then minus increment in m2 from value in j2 until i get a closely calibrated figure as close to the figure in j15 and then the same for j16 in another cell.

i have like 200 cells i need to apply this formula to so an IFstatement is better than a macro.

help me solve this and beers on the mansion.. :LOL:
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi: Water

Have you looked at the "goal seek" under the tools menu bar?

A short example might help explain

plettieri
 
L

Legacy 23340

Guest
okay a short example

okay just put in 1020 1256 in the master cells

3 in the increment cell m2

in h15 and h16 you have 71 and 89

now type subtract in l2 to subtract 3 from 1020 until you get a close enough value to 71 and the same thing in the cell with 89.

hope this demonstrates at least 1 side of the story..

i have never attempted to use goal seek, i only know 1 type of goal seeking :LOL:
 

West Man

Well-known Member
Joined
Mar 27, 2006
Messages
1,175
Do you wish only the final value that is "close" to 71, or all the intermediate values when repeatedly subtracting 3? How do you define close? Closest in terms of the absolute value of the difference, or closest that is equal to or greater than 71. I see no reason for the word subtract to be in I2 in order to meet your requirements.
 

Forum statistics

Threads
1,141,588
Messages
5,707,264
Members
421,498
Latest member
matinebi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top