What if #5

Does what you eat affect what it should be ?? YES

What if? #4

Does your weight affect wha you should be eating? YES

What if #3

What is your gender and does it affect what it should be?
YESSS

What if ? #2

Does it affect what is should be? YES

What if?

 What if your age is different does it affect what it should be.

Vlookup formulae

To use the vlookup for formula you type =VLOOKUP (double click) the select the box you want the numbers to change in the type a comma the select the data needed then comma then 2 then a close bracket and simply at the end press enter

HOW TO CALCULATE SOMEONES bmi

1. Body Mass Index Calculator: this calculator will give you an idea of how your weight compares to common values. Body Mass Index (orBMI) is calculated as your weight (in kilograms) divided by the square of your height (in metres) or BMI = Kg/M².

Be careful on what your asking

What if your person eats junk all day and thinks oh well i can have 2100 calories worth of crisps and pizza NO it should not be like that it has to be 2000 calories of A combination of everything in the food pyramid not just one.

How to help someone to get fitter or even gain weight :O

An active adult should have 2100 calories (Male)/ 2000 calories (Female)
An moderate adult should have 1800 calories/1768 calories
An unactive adult should have 1500 calories/1436 calories

An under weight adult should have 2000 calories a day male or female
an normal weight adult should have 1800 calories
an overweight adult should have 1500 calories
an obese adult should have 1300-1400 calories MAX

BMR calculations

This is the method I used to calculate a female and a males BMR

BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) + 5         (man)
BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) - 161     (woman)

Option buttons

<-------------- those are my option buttons these were more complicated to make because I had to completely edit excel to be able to have access to the options button.

Drop down list

This is my drop down list i have used this succesfully to give people an option to choose for the questions i asked the to make this drop down list I has to write down all my data go to the data tab in excel choose data validation then choose list and selected the data i wanted then pressed ok and it was on my list. :)