Re: Is this possible?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Sorry im from Plymouth England and that?s my excuse flower.
So how did you work out the formula if you haven?t read excel?

Good point Arvi I don?t think i don?t think I do explain things
correctly, I find so much lost over a cold text. I sort of got what
yours was doing with the 10% and $75 yet fail to see where the sum
whent wrong?

Next question is if I have 1% increments and not 10% then what do I
change to make the sum ?

100% $400
101% $475
102% $550
102% $625
And so forth , looking at this it seems to be $400 when equal & more
increments of $75 every percent over, I get the sum by dividing last
years number with this years and multiplying the result by 100 to get
the total percentage over or so I was told.
So $444,945 / $444,959
Im not sure where the 10% is? To change to 1% or am I missing the big
picture on your sum
=FLOOR(MAX(0,C1-B1),0.001)*1000*75+IF(C1>B1,A1,0)
Would =FLOOR(MAX(0,C1-B1),0.01)*1000*75+IF(C1>B1,A1,0) this be
correct?

Please help my brain is leaking out of the side of my head


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34988
View this thread: http://www.excelforum.com/showthread.php?threadid=548169

.

Relevant Pages

  • Re: Is this possible?
    ... About your result being different - do you have a formula or value in cell ... yours was doing with the 10% and $75 yet fail to see where the sum ... Next question is if I have 1% increments and not 10% then what do I ... phat al's Profile: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Random double-stochastic matrices
    ... sum of each row is exactly 1). ... Is that what you have in mind? ... What kind of random distribution are you seeking? ... one increments that element by a random amount delta, ...
    (comp.soft-sys.matlab)
  • Re: How can I find the greatest possible sum within 12 months? A newbie...
    ... the starting sum is in A2 and the end sum is in A123. ... date increments are random - so it is not always from a specific date ... Roger Govier schrieb: ... Excel will insert them for you. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional summation
    ... Tom Ogilvy ... "Dale" wrote in message ... > increments with the row. ... Is there a way to increment a condition in a SUM? ...
    (microsoft.public.excel.programming)
  • Re: Is this possible?
    ... have assumed that you want a zero bonus if this year's money is less than ... The total showing from that sum is 476.0000? ... What can I do to that sum to make it work? ... phat al's Profile: ...
    (microsoft.public.excel.worksheet.functions)