IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

<< < (5/12) > >>

ashiqbest012:
Thank you Mr. Aarif for your wonderful comment. Yes, I will start the tutorial about MS. Power Point after completing the Ms. Excel. Inshallah. I have to make first all of the post before posting. So, it will be  very difficult to maintain 2 section (Excel and Power point) for me.

Thank you Mr. Aarif.

faham:
Thank you Mr. Aarif for showing interest on MS Power Point.


--- Quote from: ashiqbest012 on November 21, 2010, 04:52:38 PM ---I have to make first all of the post before posting. So, it will be  very difficult to maintain 2 section (Excel and Power point) for me.

--- End quote ---
I can help you. I will start Power point tutorial and continue it. When you will finish your Excel part you can join with us. @Ashiq

ashiqbest012:



Click here for soft copy

ashiqbest012:
Formulas:

Level:
=IF(C18>9001,$B$7,IF(AND(C18>7501,C18<=9000),$B$8,IF(AND(C18>6001,C18<=7500),$B$9,IF(AND(C18>4501,C18<=6000),$B$10,IF(AND(C18>3001,C18<=4500),$B$11,IF(AND(C18>2001,C18<=3000),$B$12,IF(C18<=2000,$B$13)))))))

Bonus:
=IF(C18>9001,C18*75%,IF(AND(C18>7501,C18<=9000),C18*70%,IF(AND(C18>6001,C18<=7500),C18*65%,IF(AND(C18>4501,C18<=6000),C18*60%,IF(AND(C18>3001,C18<=4500),C18*55%,IF(AND(C18>2001,C18<=3000),C18*50%,IF(AND(C18>1,C18<=2000),C18*45%)))))))

Total Salary:
=SUM(C18+E18)

N.B: Put all of the function D18, E18, F18 no cells according to the Headline.

ashiqbest012:

--- Quote from: faham on November 21, 2010, 05:14:38 PM ---I can help you. I will start Power point tutorial and continue it. When you will finish your Excel part you can join with us. @Ashiq

--- End quote ---

It is really good news for us. We will make this forum more effective and fulfill this forum from every side. Inshallah.

We are waiting for viewing your post. It will be helpful for everyone.

Thank You Mr. Faham bhai.

Navigation

[0] Message Index

[#] Next page

[*] Previous page