D dchatrie New Member May 14, 2012 #1 I want a formula that will help me choose between these three (3) options: 1. If greater than 100% then "Targets surpassed" 2. If equal to 100% then "x% of Targets achieved" 3. If less than 100% then "Missed targets by x%"
I want a formula that will help me choose between these three (3) options: 1. If greater than 100% then "Targets surpassed" 2. If equal to 100% then "x% of Targets achieved" 3. If less than 100% then "Missed targets by x%"
Montrey Member May 14, 2012 #2 =if(a1>1,"Targets Surpassed",if(a1=1,"Targets Achieved","missed targets by x%"))
Luke M Excel Ninja Staff member May 14, 2012 #3 To add to what Montrey said: =if(a1>1,"Targets Surpassed",if(a1=1,TEXT(A1,"#%")&" of Targets Achieved","Missed targets by "&TEXT(A1,"#%")))
To add to what Montrey said: =if(a1>1,"Targets Surpassed",if(a1=1,TEXT(A1,"#%")&" of Targets Achieved","Missed targets by "&TEXT(A1,"#%")))
