Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Long condition, using IF
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |