Excel IF Then Statements

Notanexcelguru - Jul 17, 2009 at 10:18 AM
 User - Sep 8, 2009 at 01:19 PM

I am trying to figure out and make changes to spreadsheet someone else designed. Since, I haven't done elaborate spreadsheets in awhile, I need some help on an if then statement.

If CELL A is >than 1% but less than 50% then CELL B=25

If CELL A is >51% but less than 74% then CELL B=50

If CELL A is >75% then CELLB=75

There is something wrong with my computer and i have lost FrontPage on my help mneu to get me through this problem.

Thank you,

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
suppose your percentage value is in A1 , in B1 copy paste this formula and see

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;


I really appreciate your help and Notanexcelguru's question.