Help sorting out a formula

[nicolelschramartin]

I am probably missing one or more parentheses' in the formula but I need a fresh pair of eyes on this:

=IF(I11>B16,(((I11/B9)*60)+E18),IF(I11<B16,(I11/B9)*60),IF(I11=B16,(I11/B9)*60))

[Moo the Dog]

Try this:

=IF(I11>B16,(I11/B9)*60+E18,IF(I11<B16,(I11/B9)*60,IF(I11=B16,(I11/B9)*60)))

- Moo

[jamie35]

I am having trouble with this one: Hi All, I would really appreciate a solution to an if function that I am having trouble with,

If the Qty is less than 5 then the Disc% is 0%
If the Qty is between 5 and 9 inclusive then the Disc% is 2%
It the qty is 10 or greater then the Disc% is 5%

here is what i am using! IF(D8<5,0%,IF(D8=5,2%,IF(D8=6,2%,IF(D8=7,2%,IF(D8=8,2%,IF(D8=9,2%,IF(D8>=10,5%)))))))

is there another way to do this particulary for the qty between 5 and 9. thanks in advance, appreciate any help!

[Moo the Dog]

Jamie35,

You have broken Forum Rule #2:
Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Please start your own thread, with appropriate title, if you need assistance.

- Moo

[jamie35]

Thanks didnt know as first time in any forum!

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.