Forum Discussion
Solved
Calculate a percentage “From / To” range and display the two results in a single cell
Hi I am trying to work out a heart beat range for exercise. The maximum heart beat is given in cell “C3” I wish to train at a minimum to maximum percentage of the value in cell “C3” EG: I ...
Airbusjames You need to use the TEXT function if you want to format numbers that become part of a text string. Try this:
=TEXT(C3*0.7,"0")&" to "& TEXT(C3*0.8,"0")As you can see, there is no need to use SUM and /100 and *(70)
If you prefer you may also write the formula like this:
=TEXT(C3*70%,"0")&" to "& TEXT(C3*80%,"0")
Airbusjames You need to use the TEXT function if you want to format numbers that become part of a text string. Try this:
=TEXT(C3*0.7,"0")&" to "& TEXT(C3*0.8,"0")As you can see, there is no need to use SUM and /100 and *(70)
If you prefer you may also write the formula like this:
=TEXT(C3*70%,"0")&" to "& TEXT(C3*80%,"0")
