Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using a concatenate formula to combine many cells to this text string in
one cell. The number "4.05589430894309" needs to rounded to the first number after the decimal and "1.022556390977" needs to be a percentage. The cells these two numbers come from are in the appropriate formats. Yet when they go into this format below, they loose their originating formats. How do I write the formula so the formulas get transported with the correct formats? John Doe exercise for 2minutes and 26 seconds reaching stage 3 using a Accelerate Bruce protocol, achiveing an estimated workload of 4.05589430894309 METs. This corresponded to a functional capacity of Average for the patients age and sex. The heart rate was 70 bpm at baseline, and increased to 136 bpm at peak exercise, representing 1.02255639097744 of age-predicted maximal heart rate. The blood pressure response was hypotensive. Resting blood pressure was 120/80 mmHg, and peak blood pressure was 210/98 mmHg. How do I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
USE CONCATENATE function to connect 2 formulas | Excel Worksheet Functions | |||
how insert the return key in formulas for concatenate of text? | Excel Discussion (Misc queries) | |||
Combining two formulas using concatenate | Excel Worksheet Functions | |||
concatenate formulas | Excel Programming | |||
Using Concatenate to create formulas? | Excel Discussion (Misc queries) |