#4994007, By Twinkle Quick Excel Help

Twinkle 15 Jul 2009 14:32:22 542 posts
Seen 3 years ago
Registered 17 years ago

If your value is in A1:

=IF(A1="As New",0.8,IF(A1="Good",0.6,IF(A1="Fair",0.4,IF(A1="Rough",0.2,0))))