I can check if I need to increase, but how to stop when I reach a MAX?

[wkirkcrawford]

Greetings,

I've got this log and I'm checking the last three, L column, are Greater than 130, I need to increase the amount by 3.

Until I reach the maximum of 25. I'm starting off by 18. 18 + 3 = 21. Then 21 + 3 = 24. Then 24 + 3 = 25?

=IF(K15="","".IF(AND(K14>130,K13>130,K12>130)L14+3,L14) but I need to a MAX.

How can I do this check until I reach a MAX of 25.

W. Kirk Crawford
Tularosa, New Mexico

 

[FDibbins]

an untested slight variation on what you have...
=IF(K15="",",IF(sum(K14:K12)>390,L14+3,L14)

How you you know how many times you have already added 3, and what happens when you reach 25? And btw, 25 is not exactly divisible by 3, so how would you handle the remaining 1?

 

[wkirkcrawford]

Ford,

I am aware that 25 is not an incremental of 3.

I started at 18. Guess the Doctor doesn't think about such things.

W. Kirk Crawford
Tularosa, New Mexico