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...