Try this:

=IF(C6=0.25,"Approved",IF(C6=0.5,"Design",IF(C6=0. 75,"Build",IF(C6=1,"Shipped",""))))

"John Doe" wrote:


If cell c6 says: ---------------------------- I would like to
have D6 automatically say

Approved ---------------------------- 25%
or
Design ---------------------------- 50%
or
Build ---------------------------- 75%
or
Shipped ---------------------------- 100%


Any Ideas????

Thanks

John


--
John Doe
------------------------------------------------------------------------
John Doe's Profile: http://www.excelforum.com/member.php...o&userid=26826
View this thread: http://www.excelforum.com/showthread...hreadid=400756