AKA "The Raven" <bg
--
Regards,
Peo Sjoblom
(No private emails please)
"Ken Wright" wrote in message
...
Hi Poe <g
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
How can the value be <10 but 15 in your second option? Assuming there
was
a
typo and you mean 10 <15 that leaves 10 outside? Do you mean 1 <10, 2
=10 <15 and 3 =15 ?
If so you can use
=VLOOKUP(X-Y,{0,1;10,2;15,3},2)
Regards
Peo Sjoblom
(No private emails please)
"Elvin" wrote in message
...
I need to create a formula that outputs a 1, 2, or 3 based on the result
of:
If the value of x-y <10 then cell B3 = 1, If the value of x-y<10 but
15
then cell B3 = 2, If x-y<15 then cell B3 = 3.
Can I do this with formulae or do I need to go to VBA, if I need to go
to
VBA how is this calculated.
|