N Nitin Shardul Member Jun 4, 2018 #1 Dear Sir, Please find attached file for ref Regards N3 Attachments test file.xlsx 39.2 KB · Views: 9
V vletm Excel Ninja Jun 4, 2018 #2 Nitin Shardul If this works for You... Attachments test file.xlsx 38.5 KB · Views: 5
N Nitin Shardul Member Jun 4, 2018 #3 vletm said: Nitin Shardul If this works for You... Click to expand... Thanks working on this formula =IF(D8="Tourist",IF(AND($D$10<=1000),1046,IF(AND($D$10>1000,$D$10<=1500),880,IF(AND($D$10>1500),1006,"Invalid"))))
vletm said: Nitin Shardul If this works for You... Click to expand... Thanks working on this formula =IF(D8="Tourist",IF(AND($D$10<=1000),1046,IF(AND($D$10>1000,$D$10<=1500),880,IF(AND($D$10>1500),1006,"Invalid"))))
B bosco_yip Excel Ninja Jun 4, 2018 #4 Nitin Shardul said: Thanks working on this formula =IF(D8="Tourist",IF(AND($D$10<=1000),1046,IF(AND($D$10>1000,$D$10<=1500),880,IF(AND($D$10>1500),1006,"Invalid")))) Click to expand... 1] Your above formula can't work, if D8 ="Private", of which the formula returned "FALSE" 2] If you want to use IF function, try : =IF(D8="Tourist",($D$10<=1000)*1046+AND($D$10>1000,$D$10<=1500)*880+($D$10>1500)*1006,25) or, you can use vletm's Lookup formula as posted in Post #.2 which is a better proposal. Regards Bosco Last edited: Jun 4, 2018
Nitin Shardul said: Thanks working on this formula =IF(D8="Tourist",IF(AND($D$10<=1000),1046,IF(AND($D$10>1000,$D$10<=1500),880,IF(AND($D$10>1500),1006,"Invalid")))) Click to expand... 1] Your above formula can't work, if D8 ="Private", of which the formula returned "FALSE" 2] If you want to use IF function, try : =IF(D8="Tourist",($D$10<=1000)*1046+AND($D$10>1000,$D$10<=1500)*880+($D$10>1500)*1006,25) or, you can use vletm's Lookup formula as posted in Post #.2 which is a better proposal. Regards Bosco
