Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Assuming your value of 90 is in A2, put this in B2...
=A2/180 and format the cell as Percentage (if this is new to you, right-click the column header to select the entire column and click on "Format Cells" from the popup menu, then click on the Percentage item in the dialog box that appears). You can copy this formula down. For percentages of other heartbeat rates, just change the divisor from 180 to whatever rate you want (for example, 200 for your second question). Rick "cyclingStephan" wrote in message ... I want column a to have the heartbeat rate, and column b to give me what percentage of 180 that heartbeat equals. Example 90 in column a would read 50% in column b. I would then like to do this with other percentages, such as 200 being the percentage. Thank you, Stephan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Annual Percentage Rate | Excel Discussion (Misc queries) | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Annual Percentage Rate for Mortgage | Excel Discussion (Misc queries) | |||
Annual Percentage Rate | Excel Discussion (Misc queries) | |||
APR - Annual Percentage Rate | Excel Worksheet Functions |