ExcelBanter - View Single Post

wrote:
I wrote:
JOSE V via OfficeKB.com wrote (modified for readability):
BONUS CACULATIONS ARE $20 for each boat over 150
an additional 20% of this amount (units over 150 X $20)added
to amount of years the person has been a seller.

Oops! I misread the description of the arithmetic.
That simplifies the number of interpretations and
changes the formula as follows:

=(C5$B$1)*ROUND(20*(C5-$B$1)+20%*20*(C5-$B$1)+D5,0) [Petrick=$1202]
=(C5$B$1)*ROUND(20*(C5-$B$1)+20%*(20*(C5-$B$1)+D5),0) [Petrick=$1200]

I wrote those so that you can see the difference in
interpretation easily. Of course, the first formula
can be written more simply as:

=(C5$B$1)*ROUND((1+20%)*20*(C5-$B$1)+D5,0)

I hope that is closer to what you are looking for.

I will give it a try. Thanks again for the help. Jose

--
Message posted via http://www.officekb.com