Pls help me to find formula of posted matter

Knowledge resource 502 views 2 replies

CA Final

61 Points Joined November 2009

Hi friends, i attached a file pls chk it and help me to find out the formula , how i will write it in excel by using if function.. pls help me...

Thnks nd regars

AMAR

Attached File : 287140 56 pls help .doc downloaded: 132 times

Replies (2)

Guest

=IF(A1="manager of MKT",20000,IF(A1="Manager of other",18000,IF(A1="officer of MKT",15000,IF(A1="officer of other",13000))))

accountant

108 Points Joined July 2008

=IF(A1="Manager of MKT",20000,IF(A1="Manager of Other",18000,IF(A1="Officer of MKT",15000,IF(A1="Officer of Other",13000,0))))

Pls check Attachment

Your are not logged in . Please login to post replies

Click here to Login / Register