I have a datas as below:-
Marks Total
95 100
500 200
100 100
I want to apply an excel formula,If my total is > marks then should be 1,if total is < marks then should be 2 and if total is = to the marks then it should show 0.Is it possible through excel formula?
Regards
Pradeep Kumar Gupta
Gurgaon ( INDIA )
In A2 cell
95
In B2 cell
100
In C2 cell
Formula:
Please Login or Register to view this content.
Drag it down..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
or just...
=IF(B2>A2,1,IF(B2<A2,2,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
or just...
=IF(B2>A2,1,IF(B2<A2,2,0))
Thanks for the suggestion.
Thank you for your suggestion.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks