Related:

- Excel IF Then Statements
- How many if statements can you nest - Guide
- If then statements in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide

## 2 responses

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Jul 17, 2009 at 09:29 PM

Jul 17, 2009 at 09:29 PM

suppose your percentage value is in A1 , in B1 copy paste this formula and see

=IF(AND(A1>0.01,A1<0.5),25,IF(AND(A1>=0.51,A1<0.74),50,IF(A1>=0.75,75,"")))

=IF(AND(A1>0.01,A1<0.5),25,IF(AND(A1>=0.51,A1<0.74),50,IF(A1>=0.75,75,"")))

Thank you Venkat1926. I used yours with a slight modification.

If E8 contains "Months of Service", this code would give PTO personal days off based on the number;

=IF(AND(E8<12),12,IF(AND(E8>=12,E8<60),18,IF(AND(E8>=61,E8<120),23,IF(AND(E8>120),28))))

I really appreciate your help and Notanexcelguru's question.

If E8 contains "Months of Service", this code would give PTO personal days off based on the number;

=IF(AND(E8<12),12,IF(AND(E8>=12,E8<60),18,IF(AND(E8>=61,E8<120),23,IF(AND(E8>120),28))))

I really appreciate your help and Notanexcelguru's question.