IF Formula
 

First, get rid of the sum. This is a throwback to Lotus 123. Something like
this

=IF(AC2=69%,"BUILT",IF(aC2=81%,"FINISHING",IF(AC2= 94%,"ASSEMBLED",IF(AC2=100%,"COMPLETE"))),ac2)I would also start with the highest number and work my way down.=if(ac2=100%,"c",if(ac2=94%,"a",etc--Don GuillettSalesAid "Bob" wrote in ...I am trying to use the following formula it works when the cell valuematches but does not show the cell value when the formula values do not match:=IF(SUM($AC2)=69%,"BUILT",IF(SUM(AC2)=81%, "FINISHING",IF(SUM($AC2)=94%,"ASSEMBLED",IF(SUM($A C2)=100%,"COMPLETE")))) Cell AC2 contains a value from 1 to 100. I need to add something to showthe value other than the formula. Smomething like IF not ..... then AC2. Thanks for your help, Bob