View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default What percentage of heart rate

A1 = 90

B1 formula: =A1/180

format as Percentage

--
Biff
Microsoft Excel MVP


"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