Excel formula problem

  asw 21:52 04 Jun 2003

I need a formula in a cell that referances the previous cell numerical range to an alphabetical character e.g. if A1=0 to 90 then the result is N and if A1=91 to 120 then the result is E and if A1=121 to 150 then the result is D. There are a total of 6 ranges to be considered. Any suggestions would be appreciated as it's driving me nuts!!! many thanks.

  User-312386 21:57 04 Jun 2003

going to work on it now for you

will take me a little time as i have to pop out

tell me exactly where you want each answer and each cell


  VoG™ 22:18 04 Jun 2003

=IF(A1=0,"N",IF(AND(A1>=91,A1<=120),"E", IF(AND(A1<=121,A1<=150),"D")))

  Alan2 22:36 04 Jun 2003

Just looking at your suggestion and thought something not quite right. On checking it out I find the following modified version does the job.

=IF(AND(A1>=0,A1<=90),"N",IF(AND(A1>=91,A1<=120),"E", IF(AND(A1>=121,A1<=150),"D")))


  VoG™ 22:41 04 Jun 2003

Absolutely correct, thank you. However, I sense that we may ultimately be asked for a more advanced formula!

  asw 16:25 05 Jun 2003

A note to say thanks to all who responded your advice put me on the right track & saved me heaps of time, thanks again.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone