create if formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lost in Excel Land - 30 Jun 2006 22:33 GMT

A
Q

91%    93%    95%    92%    99%    97%    99%    4                    95%    95%    3
95%    95%    95%    96%    95%    96%    95%    5

if a = 95 to 100 q=5 if a = 95 t 97 Q =4    if a =92 to 94 Q=3    if a =89to91 Q=3
Is it possible to create a if function to show 1,2,3,4,5 in col. Q

Reply to this Message

Bob Phillips - 30 Jun 2006 22:46 GMT

=LOOKUP(A1,{0,90,92,95,98},{1,2,3,4,5})

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> A
> Q
[quoted text clipped - 3 lines]
>
> if a = 95 to 100 q=5 if a = 95 t 97 Q =4 if a =92 to 94 Q=3 if a =89to91

Q=3

> Is it possible to create a if function to show 1,2,3,4,5 in col. Q

Reply to this Message