Set maximum value in a column to 100 in a nested if(or

[MisterGB]

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

 

[Fluff]

Something like
=min(a1+3,100)

 

[MisterGB]

Thanks for the quick reply.

My formula starts with: =IF(OR(

How can I incorporate the min function please?

 

[MisterGB]

Disregard my post above. I entered =MIN(IF(OR then moved the cursor from left to right through the formula until the tooltip reappeared. At that point I realised that I simply neeed to add ;100).

Thanks for the help. As is always the case a little nudge and you figure it out all of a sudden and you're left feeling rather silly .

 

[Fluff]

You're welcome & thanks for the feedback.