If condition problem

[thara05]

Hi all,

This is my first post in the forum and hope to learn excel from professionals who are in this forum. Just I start to learn MS Excel and have a confuse in IF function.

This is my question, I am trying to write a function and can't seem to figure it out. Could anybody here help me write this formula correctly?

If total >= 15000                then      Total*12%
If total >= 12000                then      Total*11%
If total >= 9000                  then      Total*10%
If total >= 6000                  then      Total*9%
Else                                              Total*8%

I tried something like this but no any luck.

=IF(total>= 15000.(total/100)*12,IF(total>= 12000.(total/100)*11,IF(total>= 9000.(total/100)*10)))

any idea would be greatly appreciated.

Thank you.

 

[thara05]

@jonmo1 Thank you very much for your help. I highly appreciated.

I will start a new tread for advance filter.

hope you will find it.

thanks again

 

[Jonmo1]

You're welcome.