Ima_learnin'
Active Member
- Joined
- Dec 14, 2002
- Messages
- 266
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'
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'