# 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

( 0 reviews ) Dublin, Ireland

Project ID: #29926411

## 37 freelancers are bidding on average €91 for this job

(828 Reviews)
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 More

€250 EUR in 2 days
(249 Reviews)
8.1
(441 Reviews)
8.3
(355 Reviews)
8.0
(481 Reviews)
8.0
(235 Reviews)
6.8
(204 Reviews)
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 More

€50 EUR in 1 day
(118 Reviews)
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 in 1 day
(143 Reviews)
6.5
writingapp

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

€160 EUR in 1 day
(119 Reviews)
6.0
(120 Reviews)
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 More

€50 EUR in 1 day
(53 Reviews)
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 More

€120 EUR in 2 days
(93 Reviews)
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 More

€100 EUR in 1 day
(79 Reviews)
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 More

€30 EUR in 1 day
(35 Reviews)
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 More

€101 EUR in 7 days
(24 Reviews)
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 More

€30 EUR in 1 day
(41 Reviews)
4.4
(16 Reviews)
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 More

€30 EUR in 1 day
(18 Reviews)
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 in 1 day
(10 Reviews)
3.4