# Excel multiple functions in one cell

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Thanks for the help on the formula. I have one more for you. I would like one cell to look at four different arguments and return the result.

What I would like to do in F10 is this:
1) see if B10 + C10 is < or = 16.7 then multiply 16.7*0.6*328
2) See if B10< or = 10.02. If it is then multiply 10.02*328
3) See if B10> or = to 10.03. if it is then multiply (10.02*328) + (difference of B11-10.02) and multilply * 328
finally.....
4) See if B10 is > or = to 10.03 AND C10 is > or = 6.69 then multiply B10 * 328

I had the below argument, which worked for the first three arguments. Then I added what you sent me this morning for argument #4 and now I gen=t an error that says "too many arguments" Can you help one more time please?

1st three arguments:
=IF(B11+C11<=16.7,(16.7*0.6)*328,IF(B11<=10.02,(10.02*328),IF(B11>=10.03,(10.02*328)+((B11-10.02)*328))))

=IF(B11+C11<=16.7,(16.7*0.6)*328,IF(B11<=10.02,(10.02*328),IF(B11>=10.03,(10.02*328)+((B11-10.02)*328)),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))

Related:

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you have an extra closing bracket here

((B11-10.02)*328))

Should be
=IF(B11+C11<=16.7,(16.7*0.6)*328,IF(B11<=10.02,(10.02*328),IF(B11>=10.03,(10.02*328)+((B11-10.02)*328),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))