Encerrado

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

Habilidades: Excel, Processamento de Dados, Processamento de dados, Visual Basic

Veja mais: interest payment formula excel, excel vba lock sheet user script, creating standalone excel sheet, advertising formula excel, formula excel, excel vba access sheet data, vba excel manual calculation sheet, excel industries limited roha home page, lowest bid formula excel, creating simple excel project, creating master excel sheet generate data, home loan formula excel, how to hide formula in excel without protecting sheet, excel formula to calculate number of days between today and another date, food cost formula excel sheet, how to copy formula in excel to another sheet, food cost formula excel sheet download, how do i create a formula in excel from one sheet to another?, calculate distance between two gps coordinates formula excel, food cost formula excel sheet download free

Acerca do Empregador:
( 0 comentários ) Dublin, Ireland

ID do Projeto: #29926411

37 freelancers estão ofertando em média €91 nesse trabalho

(828 Comentários)
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 Mais

€250 EUR in 2 dias
(249 Comentários)
8.1
(441 Comentários)
8.3
(355 Comentários)
8.0
P0L

(481 Comentários)
8.0
(235 Comentários)
6.8
(204 Comentários)
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 Mais

€50 EUR em 1 dia
(118 Comentários)
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 em 1 dia
(143 Comentários)
6.5
writingapp

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

€160 EUR em 1 dia
(119 Comentários)
6.0
(120 Comentários)
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 Mais

€50 EUR em 1 dia
(53 Comentários)
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 Mais

€120 EUR in 2 dias
(93 Comentários)
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 Mais

€100 EUR em 1 dia
(79 Comentários)
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 Mais

€30 EUR em 1 dia
(35 Comentários)
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 Mais

€101 EUR in 7 dias
(24 Comentários)
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 Mais

€30 EUR em 1 dia
(41 Comentários)
4.4
(16 Comentários)
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 Mais

€30 EUR em 1 dia
(18 Comentários)
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 em 1 dia
(10 Comentários)
3.4