Excel IF Then Statements

[Closed]
Report
-
 User -
Hello,

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,
notanexcelguru

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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,"")))
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!