need a formula

[Ima_learnin']

Hi
I need a formula that if a certain cell is equal to or between .83 to .844 return “Y”, if the cell is >= .85 return “G” and finally if the cell if < .83 return “R”

I was messing around with this, but keep getting a #Value! Error.

=IF((D3>=0.83)*(D3<=0.84),"Y",""),IF(D3>=0.85,"G",""),IF(D3<0.83,"R",""))

Thanks, Ima Learnin'

 

[al_b_cnu]

Hi,

how about

=IF(A1<0.83,"R",IF(A1<0.85,"Y","G"))

HTH

Alan

 

[al_b_cnu]

Hi,

how about

=IF(A1< 0.83,"R",IF(A1< 0.85,"Y","G"))

HTH

Alan

 

[Ima_learnin']

Thanks I got mine to work with this;

=IF((D3>=0.83)*(D3<=0.84),"Y",IF(D3>=0.85,"G",IF(D3<0.83,"R",)))

however, I like your formula much better... it's very clean

Thanks!!