En cours

Write some Software

I need someone to create two formulas for me in excel. The formulas deal with averages. For example I want the excel file to recognize a value of 0 within a cell to calculate the average. If a 0 is in a cell that I do NOT want to include that in the average. Here is an example:

1 + 2 + 3 + 4 = 10 [Average is 2.5 (10/4=2.5)]

1 + 2 + 3 + 0 = 6 [Average is 2 (6/3=2)]

1 + 2 + 0 + 0 = 3 [Average is 1.5 (3/2=1.5)]

4 + 0 + 0 + 0 = 4 [Average is 4 (4/1=4)]

Attached to this email is the sample excel file. The 4 values to calculate the average will come from cells C4:C7. The result of the calculation will need to be in cell C9.

Compétences : Excel, Architecture Logicielle

Voir plus : email sample invoice attached, software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, write introductory email sample, software write books, software write protection, registration confirmation email sample, free software write book, software write book, write newspaper article sample, promotional email sample, software write technical manual

Concernant l'employeur :
( 274 commentaires ) CHICAGO, United States

N° du projet : #12690220

Décerné à :

30 $ USD en 0 jours
(320 Commentaires)
7.0

6 freelance ont fait une offre moyenne de 69 $ pour ce travail

P0L

30 $ USD en 1 jour
(120 Commentaires)
6.4
redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

30 $ USD en 0 jours
(99 Commentaires)
5.9
sergiuloghin

Hello Jason! I can help you like I did in the past. I can complete this project in 1-2 days max. You will not be dissapointed, my rehire rate is 35%. Thank you!

100 $ USD en 3 jours
(50 Commentaires)
5.2
Buffalo12

Hi there, I am a student who is currently trying to make some money on the side of school. I have lots of experience working with excel and I am very organized and I can work quickly. I am just looking for simple proje Plus

55 $ USD en 2 jours
(0 Commentaires)
0.0
freedomproject

I'm Microsoft Office Teacher in a University, I have Certified Microsoft Office Specialist, excel expert, word expert, powerpoint expert

166 $ USD en 10 jours
(0 Commentaires)
0.0