LinkBack URL
About LinkBacks
I'm trying this formula now but can't suss it out
if value is between 3 to 5 = 8
I know this is probably basic but any help would be appreciated, cheers
I'm trying this formula now but can't suss it out
if value is between 3 to 5 = 8
I know this is probably basic but any help would be appreciated, cheers
whole formula i'm trying is
from 3 to 5 = 8
from 6 to 10 = 9
11+ =10
Thanks
If the value is in A1
B1=LOOKUP(A1,{3,6,11},{8,9,10})
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks