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
AMAR NATH BARAI (CA Final) (61 Points)
12 May 2011Hi 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
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
CAclubindia
