Excel multiple functions in one cell [Closed]

- - Latest reply: rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- 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



See more 

1 reply

Best answer
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
753
5
Thank you
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,""),""))))

Say "Thank you" 5

A few words of thanks would be greatly appreciated. Add comment

CCM 6096 users have said thank you to us this month