I would like to use function to give car allowance for grade D on.
I have a worksheet in Excel there is a column titled Grade, and and another
column titled car allowance, I want to give the employee with grade D only BD 100, I tryed to use if function but I did not get the correct result. Can you help me please... |
Masoom
Just the one grade or multiples? =LOOKUP(A1,{"A","B","C","D"},{"BD400","BD300","BD2 00","BD100"}) OR =VLOOKUP(A1,table,2,FALSE) where table is a range from columns B and C Gord Dibben Excel MVP On Mon, 23 May 2005 06:55:05 -0700, Masoom Al-Omran <Masoom wrote: I have a worksheet in Excel there is a column titled Grade, and and another column titled car allowance, I want to give the employee with grade D only BD 100, I tryed to use if function but I did not get the correct result. Can you help me please... |
All times are GMT +1. The time now is 03:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com