#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default ratios


i have an average, and want to make a ratio out of it. if x=y then z=a.
is there a way i can just drag this down and get a ratio for each
number in a string of numbers?


--
RAPPEL
------------------------------------------------------------------------
RAPPEL's Profile: http://www.excelforum.com/member.php...o&userid=36240
View this thread: http://www.excelforum.com/showthread...hreadid=560186

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default ratios

Check this one out...

http://j-walk.com/ss/excel/usertips/tip81.htm

--
Mark Ivey
"RAPPEL" wrote in message ...

i have an average, and want to make a ratio out of it. if x=y then z=a.
is there a way i can just drag this down and get a ratio for each
number in a string of numbers?


--
RAPPEL
------------------------------------------------------------------------
RAPPEL's Profile: http://www.excelforum.com/member.php...o&userid=36240
View this thread: http://www.excelforum.com/showthread...hreadid=560186

Reply
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
How do I stop excel from changing my ratios into time format? Qlmmb2000 Excel Discussion (Misc queries) 3 June 26th 06 05:18 PM
Need help writing formulas in excel using ratios Excel Hack Excel Discussion (Misc queries) 0 February 15th 06 11:40 PM
Genetics with Excel: Determining ratios from Punnett Square Crosses Brett Excel Worksheet Functions 2 December 4th 05 07:33 AM
Formula for Ratios Biff Excel Worksheet Functions 0 August 26th 05 12:40 AM
How can I do finacial ratios with workings using excel? kudzie Excel Worksheet Functions 0 May 18th 05 04:33 AM


All times are GMT +1. The time now is 10:06 AM.

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

About Us

"It's about Microsoft Excel"