LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default concatenate formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
USE CONCATENATE function to connect 2 formulas Jordan Excel Worksheet Functions 4 September 30th 08 11:18 PM
how insert the return key in formulas for concatenate of text? ~0-0~ Excel Discussion (Misc queries) 2 March 18th 08 06:13 PM
Combining two formulas using concatenate Confused Kate Excel Worksheet Functions 3 September 21st 06 04:13 AM
concatenate formulas [email protected] Excel Programming 2 April 3rd 06 03:36 PM
Using Concatenate to create formulas? Thor Excel Discussion (Misc queries) 3 October 2nd 05 01:31 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"