Excel Formula
Closed
bicky@7
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017

Updated by bicky@7 on 24/01/17 at 01:58 PM
bicky@7 Posts 4 Registration date Tuesday January 24, 2017 Status Member Last seen January 25, 2017  Jan 25, 2017 at 02:52 PM
bicky@7 Posts 4 Registration date Tuesday January 24, 2017 Status Member Last seen January 25, 2017  Jan 25, 2017 at 02:52 PM
Related:
 Excel marksheet grade formula
 Excel grade formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Transfer data from one excel worksheet to another automatically formula  Guide
6 responses
bicky@7
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017
Jan 25, 2017 at 03:24 AM
Jan 25, 2017 at 03:24 AM
Sorrry sir,
The fast one was incorrect. Plz find out new one. But result always same in every cell. There are no matter what is value of it. Result always following the fast statment that i chose it display in "Best". Plz solve my problem with formula or provide me another alternative what is easiest way in this work place.
The fast one was incorrect. Plz find out new one. But result always same in every cell. There are no matter what is value of it. Result always following the fast statment that i chose it display in "Best". Plz solve my problem with formula or provide me another alternative what is easiest way in this work place.
bicky@7
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017
Updated by bicky@7 on 25/01/17 at 02:24 PM
Updated by bicky@7 on 25/01/17 at 02:24 PM
Nope !
It's not working.
Regards,
Bicky Das, bickydas00@gmail.com
It's not working.
Regards,
Bicky Das, bickydas00@gmail.com
bicky@7
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017
Updated by bicky@7 on 25/01/17 at 03:07 PM
Updated by bicky@7 on 25/01/17 at 03:07 PM
Why should we need percentage? Because need a short data not a 200,300,367marks of data. So there for we convert marks in % . After convert to % we need It's division like 1st,2nd,3rd. So we want that if a boy gets 500marks then it's percentage is 500*100/Fullmark 600 then it is 82%mark. Now it is the question is how could we put a formula that this boys mark display Best ? And other one Good and Poor/Fall.
Plz provide It's easiest way in Ms Excel.
That formula was remember by me but not now !
Regards,
Bicky Das, bickydas00@gmail.com
Didn't find the answer you are looking for?
Ask a question
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 25, 2017 at 06:06 AM
Jan 25, 2017 at 06:06 AM
biky@7, Good morning.
If in column C are percentage values, you must format it as a percentage for the formula to work.
But if in column C are values you want to know what percentage are of the values in B then use this other formula:
=IF(C2>(B2*50%), "Best", IF(C2>(B2*40%), "Good", IF(C2>(B2*30%),"Poor", "Fall")))
Is that what you want?
I hope it helps.

Belo Horizonte, Brasil.
Marcílio Lobão
If in column C are percentage values, you must format it as a percentage for the formula to work.
But if in column C are values you want to know what percentage are of the values in B then use this other formula:
=IF(C2>(B2*50%), "Best", IF(C2>(B2*40%), "Good", IF(C2>(B2*30%),"Poor", "Fall")))
Is that what you want?
I hope it helps.

Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 25, 2017 at 02:43 PM
Jan 25, 2017 at 02:43 PM
bicky@7,
The issue has no difficulty.
But, you have to clarify for us what kind of data is in column C.
If in column C, the data is a number, in the formula you can not use the % sign in the comparison.
If you want column C to be percent, then you must format it as a percentage.
The issue has no difficulty.
But, you have to clarify for us what kind of data is in column C.
If in column C, the data is a number, in the formula you can not use the % sign in the comparison.
If you want column C to be percent, then you must format it as a percentage.