Excel Formula [Closed]

Report
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017
-
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017
-
Hello sir,
. But its can't working why i dont know! Please find my attachedments.

Regards,
Bicky Das, bickydas00@gmail.com 

6 replies

Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017

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.

Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017

Nope !
It's not working.
Regards,
Bicky Das, bickydas00@gmail.com 
Posts
4
Registration date
Tuesday January 24, 2017
Status
Member
Last seen
January 25, 2017

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?
Posts
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
136
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
Posts
1854
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 4, 2020
136
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!