Lookup ?
thank you Jacob
"Jacob Skaria" wrote:
By default the value is considered as 0 So use IF condition as below
=IF(Q7="","",LOOKUP(Q7, {0,0.11,0.21,0.31},
{"0-10%","11-20%","21-30%","31%+"}))
If this post helps click Yes
---------------
Jacob Skaria
"H" wrote:
Hi, I've been using this formula
=LOOKUP(Q7, {0,0.11,0.21,0.31}, {"0-10%","11-20%","21-30%","31%+"})
but am wondering if I can add another component to it by adjusting it so
that if Q7 is blank it leaves it blank?
Is that possible?
Thanks
|