hi guys, i need your help. im using excel for our payroll. we have
different basic rate per outlet. is "if" condition limited as to the
length of statement/condition?

here's the formula that i cannot resolve since the excel cannot accept
it. what should be the formula when making long condition? please
revise my formula. many thanks!

A
outlet
MLA
binan
iloilo
davao
cebu
cdo
pam
baguio
MLA_TL
binan_TL
iloilo_TL
davao_TL
cebu_TL
cdo_TL
pam_TL
baguio_TL
BINAN_MLA

=IF(A12="MLA",357.5,(IF(A12="binan",304.7,(IF(A12= "iloilo",230,(IF(A12="davao",246.4,(IF(A12="cebu", 255.2,(IF(A12="cdo",239.8,(IF(A12="pam",300,(IF(A1 2="baguio",300,(IF(A12="MLA_TL"=401.50,(IF(A12="BI NAN_TL",401.50,(IF(A12="ILOILO_TL",308,(IF(A12="DA VAO_TL",308,(IF(A12="CEBU_TL",308,(IF(A12="CDO_TL" ,308,(IF(A12="PAM_TL",401.50,(IF(A12="BAGUIO_TL",4 01.50)))))))))))))))


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=558300