formula reqd.

K

Kirandeep Singh

Hi,

I am wanting to get a formula where if I type

1 - 99 I should get A
=100 or 199 I should get B
=200 or 299 I should get C
=300 or 399 I should get D
=400 or 499 I should get E
Click to expand...

Would appreciate any help,

Kind Regards,

Kirandeep
 
J

JulieD

Hi Kirandeep

one way
=IF(A1<100,"A",IF(A1<200,"B",IF(A1<300,"D",IF(A1<500,"E","500 or above"))))

where A1 is where you are typing your numbers

Cheers
JulieD
 
J

JE McGimpsey

One way:

=CHAR(65+INT(A1/100))

Kirandeep Singh said:
Hi,

I am wanting to get a formula where if I type

1 - 99 I should get A

Would appreciate any help,

Kind Regards,

Kirandeep
Click to expand...
 
K

Kirandeep Singh

Thank you both
:)

JulieD said:
Hi Kirandeep

one way
=IF(A1<100,"A",IF(A1<200,"B",IF(A1<300,"D",IF(A1<500,"E","500 or above"))))

where A1 is where you are typing your numbers

Cheers
JulieD
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need a formula to look up values in two columns 2
how to format cells -fill color 2
Determine next level from a table 2
Vlookup or similar 7
Excel Formula 8
Group like numbers 4
simple formula I'm sure using offset? or index? 2
validation rule for a text field 9

Top