Formula 1,2,3 division

Closed
BICKY - Jan 22, 2017 at 01:51 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jan 23, 2017 at 08:25 AM
Hello, sir

Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer?

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 23, 2017 at 08:25 AM
BICKY, Good morning.

YES. This formula works.

Remember that in your "cell address" a content must be a percentage data.

I hope it helps.
0