Hi coders I have an excel sheet that I am using to sum up some records. I am using some if statements to get results, but I am at the point where I want to break it down a little further but I am not as advanced in excel formulas as you guys are so I need some help. I have uploaded the current sheet I am using so you can get an example of what I need done.
Right now in cell T1 that is an x value that I can change to get different breakdowns of the results. I want to expand on that. Right now I have options for Correct, Incorrect and Total, but I want to expand that to Correct, Incorrect, Ties and Total. I dont know how to write that.
In the 2007 excel file in columns v and w I have added what it should look like (without the results obviously) where the ties = the T from the Q column.
Whoever gets this job and does it correctly will recieve additional work like this if they choose. I plan to add a couple different x values so I can break the data down further. Like for example when the closing total is 7 or less, 7.5 to 8.5, 8.5 to 9.5 etc or the month is april, may, june, etc.
The final thing is this is a rush project. I think for someone that knows excel well this is pretty easy and would like for someone that can start right away and finish up quickly.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).