pinar,
soon after the place where you check F3=320, the "F" does not have a closing
double quote.

The corrected formula is:
=IF(F3=334,"G",IF(F3=305,"A",IF(F3=320,"F",IF(F3=3 60,"H",IF(F3=362,"C",IF(F3=363,"P",IF(F3=580,"T",0 )))))))

I suggest you switch to a VLOOKUP function to reduce the complexity of this
formula. Further, using VLOOKUP helps you avoid hardcoding values into your
formula, but keeps it in an easily maintainable range.

"pinar" wrote:


hi
thanks a lot for the replies.
first i tried to make it with if function but it gives error
i wrote this;
=IF(F3=334,"G",IF(F3=305,"A",IF(F3=320,"F,IF(F3=36 0,"H",IF(F3=362,"C",IF(F3=363,"P",IF(F3=580,"T",0) ))))))

did i make something wrong??


--
pinar
------------------------------------------------------------------------
pinar's Profile: http://www.excelforum.com/member.php...o&userid=16067
View this thread: http://www.excelforum.com/showthread...hreadid=275198