# Creating a formula in excel

I am looking at a formula for the following:

Sheet Charting

If Home Hyper F16 has a value, it checks sheet 2-20 Data Between rows DH4:DN17 (For Male) and for Female DP4:DVB17 where this value is in that range and returns the 0/50/80/93/95/98 (a percentile). The result is in G16

It also checks the age (5-7, 8-10, 11-13, 14-17) to check which row and column it brings back.

The age is in Charting F7, the Gender is J4 (Male or Female which itself is linked to sheet Patient C15

If School Hyper F17 has a value, it checks sheet 2-20 Data between rows DX4:ED17 for Males and EF4:EL17 for Females. The result is in G17

Once I know what formula to insert, I can then do it for the rest of the data. Im just not sure how to IF(AND) all those together, im sure it can be done.

So in summary: Score in Inat F16 (Charting), checks if patient male/female (J4 or Patient!C5), Age of patient, then goes to sheet 2-20Data and looks at rows DH4:DN17 (For Male) and for Female DP4:DVB17 where this value is in that range and returns the 0/50/80/93/95/98 (a percentile).

It also checks the age range (5-7, 8-10, 11-13, 14-17) to check which row and column it brings back that percentile at the top

It then puts in that percentile in Charting!G16

Tietoa työnantajasta:
( 0 arvostelua ) Dublin, Ireland

Projektin tunnus: #29926411

## 37 freelanceria on tarjonnut keskimäärin €91 tähän työhön

(828 arvostelua)
8.8
asin1987

Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews he Lisää

€250 EUR 2 päivässä
(249 arvostelua)
8.1
(441 arvostelua)
8.3
(355 arvostelua)
8.0
(481 arvostelua)
8.0
(235 arvostelua)
6.8
(204 arvostelua)
6.9
daniyal3214

Hello, I just read your project description and will be glad to assist you with that on top priority basis. I am an experienced Data Analyst and advance level Excel user. Data Analytics, Automation and Data Visualizati Lisää

€50 EUR 1 päivässä
(118 arvostelua)
6.7
finecodervw

Hi, I am well versed with Excel formulas and macro for automation and can help to put the required values in Charting sheet.. A quick discussion would help. Looking forward to your response. Thanks

€60 EUR 1 päivässä
(143 arvostelua)
6.5
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

€160 EUR 1 päivässä
(119 arvostelua)
6.0
(120 arvostelua)
6.0
AkilaArun

Hi, I am interested in working on the task. I have 7 years of experience working with Excel , excel VBA related tasks. Saw the file and description. Looking forward to discuss in detail about the task. Best Regards, A Lisää

€50 EUR 1 päivässä
(53 arvostelua)
5.7
merinsinha

I can create excel formula according to your requirement. Hi i am an Senior Excel VBA , Macro Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I bel Lisää

€120 EUR 2 päivässä
(93 arvostelua)
5.1
mhfsha

Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of Excel formulas virus t Lisää

€100 EUR 1 päivässä
(79 arvostelua)
5.1
professional800

Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. i would apply all these formula accordingly. I am full- time freelancer having job experience of more t Lisää

€30 EUR 1 päivässä
(35 arvostelua)
4.7
Jatin77777

Hello, I have gone through with contents and understand the requirements. This is a pretty straightforward task and I am interested to do this work and break your huddle. Please allow me to do this job. I am available Lisää

€101 EUR 7 päivässä
(24 arvostelua)
4.7
AccountantArman

"Sir, I can make you an easy formula, I am expert in it. I am Excel Advance Level Expert. This is a basic work for me. i can complete this project with in Few hours with added quality. About me I am Chartered Account Lisää

€30 EUR 1 päivässä
(41 arvostelua)
4.4
(16 arvostelua)
4.2
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Lisää

€30 EUR 1 päivässä
(18 arvostelua)
3.7
jojimathew571

Hi there, It is a very interesting task and I would love to work in it. I have a few questions needing clarification and once the answers are clear I am ready to get started. Look forward to work with you.

€50 EUR 1 päivässä
(10 arvostelua)
3.4