Conditional Formatting Help

J

John Doe

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
 
D

David Hepner

Try this:

=IF(C6=0.25,"Approved",IF(C6=0.5,"Design",IF(C6=0.75,"Build",IF(C6=1,"Shipped",""))))
 
Top