Finding the Min number needed, for bottom cell to be greater than top?

Hi, sorry for posting this twice but i wasn't sure which category it fell under!

I have a slight problem with excel and and was wondering if anyone can help.

I have 3 columns, A, B, C:

Column A= Uncorrected Number
Column B= Correction Factor
Column C=Corrected Number (Column A-ColumnB)

Column A Column B Column C
2.40 0.51 1.89
2.45 0.49 1.96
2.47 0.55 1.92

Problem:

In Column C, the value in any Cell cannot be less than the number before it! ie, row 3 is incorrect and should be 1.961 or greater etc.

I've tried using a goal seek function but it does not allow me to solve it for an equation, for example setting my to value as being C2>C1. Can anyone help me with this problem? It would be much appreciated. Thanks

=if(a12-b12>c11;a12-b12;c11)

So you just want to add 0.001 if the subtraction yields value smaller than value above?

Try:

=MAX(A2-B2,C1+0.001)

in C2, copied down.

Sorry i couldnt get that to work, i forgot to mention that i dont want the increase to be greater than the number after say like this :

Column A Column B Column C
2.40 0.51 1.89
2.45 0.49 1.96
2.47 0.55 1.92
2.45 0.47 1.98

See my post to determine if that is what you need.

What's not quite it?

What should it be?

Sure,

in the reply box, click the paperclip icon to browse and upload your file

Hi,

May be this in D2 copied down?

=IF(A2-B2<D1,D1,A2-B2)

See attached...

I formatted column F to 8 digits to show the numbers are larger as you go down.. if you need to show the rounded figures to be larger we will need to introduce the Round() function.

I am glad that is what you needed.

Can you now please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

What do you mean by minimum correction factor? How do you arrive at one?

Wouldn't that be just a matter of changing the 0.001 in my formula to your correction factor reference, i.e column C

so formula in F6 would now be:

=IF(A6-C6<F5,F5+C6,A6-C6)

See attached.

When you say things like "it doesn't work" you need to describe exactly what is wrong. Why doesn't it work? And what should it be?

Well some of the correction factors in column C are negative.. causing the items in F to go downward... what "factor" should it use then?

Better to continue here... so others benefit/can contribute.