Excel formula with IF Function to enter employee band

HRakash

This is first time I am posting question regarding spreadsheet formula error.
In attached screenshot, grades are given for respective employees, I want to enter their band via if function under band column. (=IF(F2= A,"50", Grade B="40", Grade C="30", Grade D="20").

1 Attachment(s) [Login To View]

anoop-shanker

=IF(f2="A",50,IF(f2="B",40,IF(f2="C",30,IF(f2="D", 20,0))))

HRakash

Hi Annonymous, thanks a million, it worked, wow my post was resolved immediately. thank you so much.
Thanks and Regards,
Akash Sharma

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute