Thread
:
If value between 2 numbers
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
GS[_2_]
external usenet poster
Posts: 3,514
If value between 2 numbers
on 10/12/2012,
supposed :
=LOOKUP(C1,{1,20,50,75},{"Low","Med","High","Heavy "})
Howard,
Exactly what I would do in a real project because it's more efficient
(and self-explanatory to me). I chose to follow the OP's logic
combining IF/AND functions for learning benefit (hopefully).<g
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB
Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb
.general.discussion
Reply With Quote
GS[_2_]
View Public Profile
Find all posts by GS[_2_]