What is an if statement ?
The if statement executes a statement if a specified condition is true. If the condition is false, another statement can be executed.
Some examples of the if statements below are from the excel calories counter are below
1) What if a person eats junk all day?
If i eat eat junk all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy.
screen shot below
2) What if they eat healthy?
If i eat healthy all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy.
screen shots below
3) What is the calorie intake ?
your calorie intake is recommended on your BMI and gender.The term BMI stands for body mass index. In order to find someones BMI you have to know the formulas below :
The if statement executes a statement if a specified condition is true. If the condition is false, another statement can be executed.
Some examples of the if statements below are from the excel calories counter are below
1) What if a person eats junk all day?
If i eat eat junk all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy.
screen shot below
2) What if they eat healthy?
If i eat healthy all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy.
screen shots below
3) What is the calorie intake ?
your calorie intake is recommended on your BMI and gender.The term BMI stands for body mass index. In order to find someones BMI you have to know the formulas below :
| 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) Next you have to make an if statement and type in the formula below screen shot provided |
Wow Hadeya!
ReplyDeleteYou have given so much detail and what if predictions! You could hide some cells that are not needed and also try to name your sheets instead of keeping them as 'sheet 1' so your work can be organized! Fabulous work!
ReplyDeleteGood Calorie Counter, you should name your sheets and hide some of your cells.
ReplyDeleteI totally agree will surely work on that
ReplyDeletewhen presenting work try cropping it to presnet it better
ReplyDelete