Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I searched & searched for an old post to cover this but nothing out there.
I have the following formula that is got an error in it: =IF(I2<30, "< 30"), IF(AND(I2=30, I2<=60),"31-60"), IF(AND(I260, I2<=90),"61-90"), IF(I2=91, " 91") my goal is tot have the following for statements placed in a cell via this calculation to cover 4 possible variables. if number is then or equal to 30 then tag "<30" if number is 31 or greater and 60 or less then tag "31-60" if number is greater then 60 but less then or equal to 90 then tag "61-90" if number is greater then or equal to 91 then tag "91+" I use to do these all the time what is up with this formula: Thanks Todd Frisch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions |