HRakash
23

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

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

anoop-shanker
2

=IF(f2="A",50,IF(f2="B",40,IF(f2="C",30,IF(f2="D",20,0))))
From India, Chennai
HRakash
23

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





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.