Lukket

Excel If Statement Worksheet

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.

## Deliverables

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

## Platform

excel

Evner: Lidt af Hvert, Ingeniørarbejde, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: where can you look for coders, where can i hire coders, v coders, june is the month for, i need excel help, get q coder, for the month of june, excel advanced 2010, excel 2010 advanced, advanced excel formulas, what is a w-9 form, what is a w-8 form, w-9 what is it, how to get an engineering job, need excel help, how to write statement, excel party hire, think-cell, q-v, hire excel help

Om arbejdsgiveren:
( 243 bedømmelser ) Chicago, United States

Projekt ID: #3316621

21 freelancere byder i gennemsnit $26 på dette job

shikhamehta

See private message.

$15.3 USD på 1 dag
(300 bedømmelser)
7.0
dominique1

See private message.

$34 USD på 1 dag
(454 bedømmelser)
6.5
jaypatel512

See private message.

$12.75 USD på 1 dag
(67 bedømmelser)
5.8
avosoft

See private message.

$42.5 USD på 1 dag
(34 bedømmelser)
4.9
excelsolution

See private message.

$12.75 USD på 1 dag
(66 bedømmelser)
4.8
syedmahtab

See private message.

$7.65 USD på 1 dag
(38 bedømmelser)
4.7
Dutchmatlab

See private message.

$85 USD på 1 dag
(35 bedømmelser)
4.7
yubor

See private message.

$25.5 USD på 1 dag
(31 bedømmelser)
4.4
shaarawi

See private message.

$8.5 USD på 1 dag
(30 bedømmelser)
4.0
MalayKothari

See private message.

$68 USD på 1 dag
(3 bedømmelser)
3.2
mraheelgujjar

See private message.

$17 USD på 1 dag
(19 bedømmelser)
3.1
dale4id

See private message.

$12.75 USD på 1 dag
(11 bedømmelser)
2.2
bismarck555

See private message.

$17 USD på 1 dag
(5 bedømmelser)
1.6
gbid

See private message.

$25.5 USD på 1 dag
(2 bedømmelser)
0.9
gigattarivw

See private message.

$8.5 USD på 1 dag
(2 bedømmelser)
0.0
khurramabbasi

See private message.

$17 USD på 1 dag
(0 bedømmelser)
0.0
hollvw

See private message.

$21.25 USD på 1 dag
(0 bedømmelser)
0.0
germancodervw

See private message.

$12.75 USD på 1 dag
(0 bedømmelser)
0.0
vw7493240vw

See private message.

$34 USD på 1 dag
(0 bedømmelser)
0.0
mahimams

See private message.

$42.5 USD på 1 dag
(1 bedømmelse)
0.0