Excel formula with IF Function to enter employee band

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").
8th May 2018 From India, Delhi

Attached Files (Download Requires Membership)

excel error screenshot.docx (184.0 KB, 201 views)

Add Reply → Start New →

anoop-shanker

=IF(f2="A",50,IF(f2="B",40,IF(f2="C",30,IF(f2="D",20,0))))
8th May 2018 From India, Chennai

HRakash

Hi Annonymous, thanks a million, it worked, wow my post was resolved immediately. thank you so much. Thanks and Regards, Akash Sharma
8th May 2018 From India, Delhi

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.

Other Discussions That May Be Relevant

Itr 1 in excel for ay 2014-15 with auto fill function.

Countif function in excel - how to use it to avoid duplicate entries?

Payroll in excel - how to establish a payroll system - formula required

Related Files & Downloads Shared By Members