Formula calculation with a max value

B

bryanp21

New member
Joined
Nov 30, 2012
Messages
1
Reaction score
0
Points
0
I'm adding two cells together and multiplying by 3(=sum(a1:b1)*3), but I don't want the total to exceed 15. Is there a way to do this? Below is an example of what I'm doing.

Cell A1 has a value of 5 and cell B1 has a value of 12. I want to subtract cell A1(5) from cell B1(12), then multiply times 3.
=sum(a1:b1)*3
This will give me a value of 21, but I need the maximum value to be 15.

Can someone please help!!

Thanks​
 
Hi,

you could use MIN,

If you need to sum A1 and B1

=MIN((A1+B1)*3,15)

If you'd need a subtraction instead

=MIN((B1-A1)*3,15)

Hope it helps
 
You must log in or register to reply here.
Back
Top