# 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
Hello sir,
. But its can't working why i dont know! Please find my attachedments.

Regards,
Bicky Das, bickydas00@gmail.com

## 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
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.

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
Nope !
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
In "C" Colum is percentage or mark. B2*100/ full mark 600
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
Which field do you intend to compare?
B2 or C2?

Didn't find the answer you are looking for?

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.