Pls help me to find formula of posted matter

AMAR NATH BARAI (CA Final) (61 Points)

12 May 2011

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

Reply
Follow
Share

2 Replies

(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))))

dattatreya Sarma (accountant) (108 Points)
Replied 23 May 2011

=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

Attached File : 73095 722198 book1.xls downloaded: 254 times

Start a New Discussion