Dear Sir / Ma’am Please use the following formula =IF(A1>=15000,"Greater than 15000","Less Than 15000") A1 - Select cell where your value is entered
From India
Acknowledge(0)
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.
Other Discussions That May Be Relevant
Excel salary calculation formulas for pf - assistance provided Hi i am working on salary calculations in excel and facing an issue regarding pf calculation. we have set our basic salary at 6500 for 30 days for employees whose... 5 Replies1 Files6 Participants
Figures to words as discussed by amit - txt download Press altf11 on excel then go to modules below on the left and paste the notepad text attached here. save close and come back to excel. then in the formula... 3 Replies1 Files3 Participants
Excel formula formatting assistance needed urgently Dear all can anyone help me with excel formula formatting i.e. powerpoint/excel sheet? please help i need it urgently. warm regards renuka... 2 Replies2 Files2 Participants
How to calculate average in excell attached - rar download Dear friends please find the attached excel sheet and instructions on how to calculate the average. it s very important. if there is any formula please let me know as... 2 Replies1 Files2 Participants
Excel formula with if function to enter employee band 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... 2 Replies1 Files2 Participants