I have a formula that adds a value to the cell above it depending on the text in an adjacent cell to the left. This formula has multiple If and if(or components). The values added are fixed and not based upon any other cells.
Say that A1 is 98 and in A2 the formula adds 3 then instead of being 101, I need it to effectively ignore the additional 1 and stop at 100.
I'm aware of the function Min, but not sure how to incorporate it into the formula.
Thanks in advance,
GB
Say that A1 is 98 and in A2 the formula adds 3 then instead of being 101, I need it to effectively ignore the additional 1 and stop at 100.
I'm aware of the function Min, but not sure how to incorporate it into the formula.
Thanks in advance,
GB