Search : in
By :

Excel IF Then Statements

Last answer on Sep 8, 2009 6:19:04 pm BST Notanexcelguru, on Jul 17, 2009 3:18:20 pm BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 8.0/Excel 2003

Best answers for « Excel IF Then Statements » in :
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Sorting a table without using the sort function ShowSorting a table without using the sort function Getting started Pseudocode The coding Getting started First of all we initialize a variable $ max with the 1st value of table. Then we will make a loop until the table still contains...
Basic Excel Formulas 2 ShowBasic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

venkat1926, on Jul 18, 2009 2:29:48 am BST

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

   
Reply to venkat1926

2

 User, on Sep 8, 2009 6:19:04 pm BST

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.

   
Reply to User
Ask your question Reply
They need your help