No Tags Found!


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(0)
Amend(0)

Hi Annonymous, thanks a million, it worked, wow my post was resolved immediately. thank you so much. Thanks and Regards, Akash Sharma
From India, Delhi
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.