Thread: Need help on some calculations..
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default Need help on some calculations..
Oops, correction:
Put in C3: =B3+15*(B3/SUM($B$3:$B$6))

should be:
Put in C3: =B3+$C$2*(B3/SUM($B$3:$B$6))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


Reply With QuoteReply With Quote