thanks to Bob and Zack -

now, I've got a long if statement, but it's not working perfectly yet. Do I
need to have ampersands or quotes anywhere that I missed? Do I have my less
than/greater than/equal signs mixed up?

=IF(G4<=0.249,"A",(IF(G4=0.25<=0.399,"B",(IF(G4= 0.4<=0.499,"C",(IF(G4=0.5<=0.599,"D",(IF(G4=0.6< =0.849,"E",(IF(G4=0.85<=1.749,"F",(IF(G4=1.75<=3 .149,"G",(IF(G4=3.15<=99.999,"H","")))))))))))))) )

I'm trying to have this cell compute a letter (A thru H) based on ranges.

Thanks!


"Bob Phillips" wrote:

Example

A1:17
B1:=A1*2
C1:=IF(B130,"30","<30")

is that what you mean?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Judy" wrote in message
...
Can anyone provide instruction on how to make a secondary function (in a
separate column) look up the value (result) of the first function without
having to paste the values. Thanks in advance!