Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum
Private Group for paid up members of Boards.ie. Join the club.
Private Group for paid up members of Boards.ie. Join the club.
Excel Name usage question
-
29-08-2020 10:33PM#1Firstly, I have very little knoledge using Excel formulas, so any replies will need to be based on the fact I'm not overly firmiliar with this stuff.
I have what appears to be a very simple BMI calculator Excel spreadsheet. It works fine by simply displaying one's BMI based on the input of both weight & height.
The result is displayed in a cell in figures.
Here's what I want to do.
I want to add a result column that will display a name based on the result.
The criteria for the name related to the result is as follows.
• Below 18.5 = Underweight
• 18.5 to 24.9 = Normal
• 25 to 29.9 = Overweight
• Above 30 = Obese
So I want cells in the result column to display Underweight, Normal. Overweight or Obese depending on the figure in the BMI calculated cell.
Example of sheet:
In the above example the BMI is 26.5625 so I would want the result cell to display Overweight."Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid."
0
Comments
-
Gadgetman496 wrote: »Firstly, I have very little knoledge using Excel formulas, so any replies will need to be based on the fact I'm not overly firmiliar with this stuff.
I have what appears to be a very simple BMI calculator Excel spreadsheet. It works fine by simply displaying one's BMI based on the input of both weight & height.
The result is displayed in a cell in figures.
Here's what I want to do.
I want to add a result column that will display a name based on the result.
The criteria for the name related to the result is as follows.
• Below 18.5 = Underweight
• 18.5 to 24.9 = Normal
• 25 to 29.9 = Overweight
• Above 30 = Obese
So I want cells in the result column to display Underweight, Normal. Overweight or Obese depending on the figure in the BMI calculated cell.
Example of sheet:
You can use a nested if statement, Google for exact format but basically
If the cell <18, underweight and so on.0 -
-
-
The Tetrarch wrote: »Put the weight in cell A1
Put this in cell B1
=IF(A1<18.5,"Underweight",IF(AND(A1>=18.5,A1<=24.9),"Normal",IF(AND(A1>=25,A1<=29.9),"Overweight",IF(A1>=30,"Obese"))))smuggler.ie wrote: »Just to avoid "underweight" in empty rows, could try tiny mod to same formula
=IF(A2<>"",IF(A2<18.5,"Underweight",IF(AND(A2>=18.5,A2<=24.9),"Normal",IF(AND(A2>=25,A2<=29.9),"Overweight",IF(A2>=30,"Obese")))),"")
Thank you both so much. This is really helpful
"Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid."
0
Advertisement