Thread: fomula required
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default fomula required

=B3/SUM(B1:B2)
Click yes if helped
--
Greatly appreciated
Eva


"Keith" wrote:

I'm attempting to get a formula to reflect as a %.

A1: $4 (a stock high)
A2: $2 (a stock low)
A3: $3 (current price)

How can I get a formula to show the current price of the range as a %, in
this case it would show 50%.