Thread: excel formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shone33 Shone33 is offline
external usenet poster
 
Posts: 9
Default excel formula


I have a 4 canidates. I have allen, webb, parker, and write in.
parker has 136 votes
allen already has 5059 votes and will take 66% of parker votes
webb already has 4704 votes and will take 24% of parker votes
what ever is left will remain parker. I want to know is the formula that I
used =SUM(D7*0.66+B7) correct to get each individual total votes
"Max" wrote:

Some thoughts ..

Don't understand your logic and how it all gells,
but as posted, your formula below contains redundancy
=SUM(D7*0.66+B7)


Above could be written as either
=SUM(D7*0.66,B7)

or simply:
=D7*0.66+B7

Suggest you start a new thread for your underlying query. Elaborate further
exactly what you have (eg what's in D7 - another formula?, a value?, what
does D7 stand for, what's in B7, etc. Explain with sample data, & expected
results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Shone33" wrote:
If parker has 136 votes and allen will receive 66% of parker votes and then
webb will receive 24% of parker votes. and then parker will keep the
remaining votes. what formula do i use. I tried =SUM(D7*0.66+B7). this
formula also added webb and allen current votes. was this formula correct?