This is the first time I am posting a question regarding a spreadsheet formula error.

In the attached screenshot, grades are given for respective employees. I want to enter their band via an IF function under the band column.

(=IF(F2= A, "50", Grade B= "40", Grade C= "30", Grade D= "20"))

From India, Delhi
Attached Files (Download Requires Membership)
File Type: docx excel error screenshot.docx (184.0 KB, 202 views)

Acknowledge(0)
Amend(0)

=IF(f2="A",50,IF(f2="B",40,IF(f2="C",30,IF(f2="D",20,0))))
From India, Chennai
Acknowledge(1)
HR
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.