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..

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hi: Water

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

A short example might help explain

plettieri

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

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.

Replies
5
Views
469
Replies
2
Views
401
Replies
6
Views
779
Replies
10
Views
210
Replies
2
Views
143

1,219,997
Messages
6,151,365
Members
451,022
Latest member
Baijano23

### 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.

### Which adblocker are you using?

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

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