Return Text Based On Cell Percentage

Re: Comparrison Of Cells To Text

[frc]=INDEX({"<=30%","<=60%",">=60%"},1,MATCH(A1,{0,0.31,0.61},1))[/frc]

Re: Return Text Based On Cell Percentage

I interpreted the question differently than Dave... not sure if this helps
I thought you are asking how to change text based on cell value in percentage...

[frc]=IF(A1<0.3,"Less than 30%",IF(A1<0.6,"Less than 60%","Greater than 60%"))[/frc]

Re: Return Text Based On Cell Percentage

Value in A1

Formula in B1:
=IF(A1<.3=TRUE,"less than 30%",IF(A1>.6,"Greater than 60%",IF(OR(A1>.3=TRUE,A1<.6=TRUE),"Between 30% and 60%",0)))

This will solve the problem using a combined "IF" and "OR" statement.

Syntax for an IF statement: IF(Logical_Test,value_if_True,Value_if_False)

The Argument must be set up as follows:
1. IF value is below 30, True
...............Else..................
2. IF value is above 60, True
...............Else..................
3 IF value is above 30 or below 60, True

While the last argument, #3, would make any number "True" the previous arguments, #1 & #2, restrict the "OR" statement to the values that failed the the first and second argument, the values between and including 30 & 60.

For a decent video tutorial see this link
http://www.tutorialized.com/view/tutorial/AND-OR-in-Excel/23342

Regards,
-Dude 8-)

Re: Return Text Based On Cell Percentage

Quote from ianmoore

Yogendra
This is correct

If cell <30% Then Text. If same cell Between 30 to 60 % text, If greater than 60% Text

Sorry for the confusion

That is what my formula does.