How to set up a formula in excel with 2 functons ( Use this formula if... OR use this fromula if...) help!!!!

Question

Im trying to write a formula that if the sum of the range b2:02 is less than 80 then multiply the sum by 9 or if the sum of b2:o2 is higher than 80 just multiply 80 by 9
or if u know a better way to write it let me know i just want it to multiply only 80 by 9 if the sum is higher than 80 and if its less than 80 then at that point multiply the sum by 9

IF(SUM(B2:O2)<80,(SUM(B2:O2))*9,) or IF(SUM(B2:O2)>80,(80*9))

Answer 1

With your particular question, it appears you only desire 1 of 2 possible answers: If the sum is > 80 and if the sum is < 80. Before I give the answer to this, a return question is: What do you want to do if the value is 80?

now for you particular question, only 1 of the 2 options can be true. The IF statement is ideal because you can give a result for True and a result if it is False.

The format of the IF formula is:

IF(check to be true or false, what to do if true, what to do if false)

Here is the formula:
=IF(SUM(B2:O2)<80,SUM(B2:O2) * 9,720)

I put 720 in place of 80*9 because it will always be 720.

Hope this helps

Answer 2

=IF(SUM(B2:O2)<80,(SUM(B2:O2)*9),(80*9))
hold your mouse over the formula to see the whole thing

=IF .. LOGICAL TEST , If its true do this , if its false do this
If the sum of B2 through O2 is less than 80 then multiply that sum by 9, otherwise multiply 80 by 9

Answer 3

IF(SUM(B2:O2)<80,SUM(B2:O2)*9,80*9)

All you needed was the third default term. it will now return 80*9 or 720 every time the sum is 80 or greater.

Hope this helps!