Hi pro,

I like excel so much and I have written a post about nested if. I would like to summary my post about what we can do with nested if in excel:

- How many number of If inside one nested if formula
- Basic applied: convert mark from number into text
- Calculate commission based on volumn of sale
- Or we can make an interative sale report with multiple if statement
-....

Many things we can do with it, is'nt it?

And I am eager to receive your advices, ideas,... about this topic.

If allowed, i will add your comments to make my post more interesting and to be a good source for excel learner.

Thanks alot for reading and building spirit.

Here is the link to my post: http://azexcel.com/multiple-if-state...d-if-in-excel/