Excel multiple functions in one cell

Closed
todd - May 3, 2010 at 10:18 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2010 at 10:44 AM
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))))

Added 4th argument and received error "too many 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(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))

Thanks for your help



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 3, 2010 at 10:44 AM
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,""),""))))
5