Hi experts!
I have a project to do given to me by a doctor that has a series of blood
pressure results (numbers) from various patients. And would like me to give
him the average blood pressure result.
How can I get Excel 2007 to convert the 120/80 into a format that will allow
me to find
see if it helps
On Sun, Mar 27, 2011 at 10:58 PM, Susan sunni...@gmail.com wrote:
Hi experts!
I have a project to do given to me by a doctor that has a series of blood
pressure results (numbers) from various patients. And would like me to give
him the average blood pressure result.
please try this Array formula
=ROUND(AVERAGE(--LEFT(A1:A3,3)),0)/ROUND(AVERAGE(--RIGHT(A1:A3,2)),0)
Array Formula needs to be entered with 3 keys : Ctrl + Shift, Enter !
On Mon, Mar 28, 2011 at 12:28 AM, Susan sunni...@gmail.com wrote:
Hi experts!
I have a project to do given to me by a
Yes that works great!
~S
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Sunday, March 27, 2011 6:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to convert a (blood pressure number
120/80) to a format that