Hi,
I've huge keyword data with competition value and i want to use the following condition with all the nos.
I've numbers in the excel sheet and i want convert those numbers in 3 text value using the following parameters:
Low — under .33
Medium — between .33 and .66
High — over .67
How can i do it using IF less than or greater than formula or is there any other option to get it.
Please help me to solve it asap.
Thank You all..!!!
In A1 cell
.35
In B1 cell
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Perhaps something like this?
=IF(A1<0.33,"lOW",IF(AND(A1>=0.33,A1<=0.66),"Medium","High")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you so much ... :-)
Thank You sixthsense..!!
Thank You fotis..!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks