THKUCOMEAGAIN
New Member
- Joined
- Jan 5, 2012
- Messages
- 12
ok i am working on this this excel program and i have just about finished it, but i cant for the life of me figure out how to make a range of number EX(0-100) to apear in a cell in that format. I am trying to calculate the BMI of people. Now the BMI has a range in itself. Like it goes up to 18.4 is the fist interval then it goes 18.5- 24.9 and so i have made a formula to calculate the weights of the people based on their BMI that i get from another formula. I got the formula that calcs the Weight off the BMI calculating the lowest end of the BMI range EX (.01) and the highest interval within the BMI range witch would be EX (18.4)
so i got those to calculations in 2 different cells now but i need to get them to appear as a range in one cell up in my main calculater
understand
EX:
I need .01 in cel G25 and 143.6 in cell F25 to appear as a range (.01-143.6) in cell D 12 how do i do this plz help its for a school project and i cant seem to figure out how to do this
so i got those to calculations in 2 different cells now but i need to get them to appear as a range in one cell up in my main calculater
understand
EX:
I need .01 in cel G25 and 143.6 in cell F25 to appear as a range (.01-143.6) in cell D 12 how do i do this plz help its for a school project and i cant seem to figure out how to do this