wkirkcrawford
Board Regular
- Joined
- Dec 7, 2013
- Messages
- 72
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
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