# 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

Om arbejdsgiveren:
( 0 bedømmelser ) Dublin, Ireland

Projekt ID: #29926411

## 37 freelancere byder i gennemsnit €91 timen for dette job

(828 bedømmelser)
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 Flere

€250 EUR in 2 dage
(249 bedømmelser)
8.1
(441 bedømmelser)
8.3
(355 bedømmelser)
8.0
(481 bedømmelser)
8.0
(235 bedømmelser)
6.8
(204 bedømmelser)
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 Flere

€50 EUR på 1 dag
(118 bedømmelser)
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 på 1 dag
(143 bedømmelser)
6.5
writingapp

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

€160 EUR på 1 dag
(119 bedømmelser)
6.0
(120 bedømmelser)
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 Flere

€50 EUR på 1 dag
(53 bedømmelser)
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 Flere

€120 EUR in 2 dage
(93 bedømmelser)
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 Flere

€100 EUR på 1 dag
(79 bedømmelser)
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 Flere

€30 EUR på 1 dag
(35 bedømmelser)
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 Flere

€101 EUR in 7 dage
(24 bedømmelser)
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 Flere

€30 EUR på 1 dag
(41 bedømmelser)
4.4
(16 bedømmelser)
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 Flere

€30 EUR på 1 dag
(18 bedømmelser)
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 på 1 dag
(10 bedømmelser)
3.4