Can anybody advise
If cell <30% "TEXT" but not grater than 60%"TEXT" If greater than 60% "Text"
I Require a formula to indicate above can anybody help please
Thanks in anticipation
Can anybody advise
If cell <30% "TEXT" but not grater than 60%"TEXT" If greater than 60% "Text"
I Require a formula to indicate above can anybody help please
Thanks in anticipation
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
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
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-)
Don’t have an account yet? Register yourself now and be a part of our community!