Hi
I am looking for a function that gives a range of numbers a score, here is what i need:
if A1 is between 6&15 B1=25 if A1 is between 16&35 B1=15 if A1 is between 36&65 B1=5 if A1 is 66 or more B1=0
Thank you
Hi
I am looking for a function that gives a range of numbers a score, here is what i need:
if A1 is between 6&15 B1=25 if A1 is between 16&35 B1=15 if A1 is between 36&65 B1=5 if A1 is 66 or more B1=0
Thank you
if(a1>65,0,if(a1>35,5,if(a1>15,15,if(a1>5,25,"Nothing specified for this"))))
Click * below if this answer helped
hi MATU. try:
=LOOKUP(A1,{6,16,36,66},{25,15,5,0})
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi benishiryo
that formula is great and works but when no data is in A1 B1 returns #N/A , How do i get rid of the error?
Hi,
You can use Iferror formula to avoid such error...
=IFERROR(LOOKUP(A1,{6,16,36,66},{25,15,5,0}),"")
Thank you K.Raja
Your a STAR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks