cost mark up function?

[obucdow]

I need a cost mark up function to show mark up at 10% 15% and 20%, when I get my value, I need it to be rounded up the nearest cent.

any help would be greatly appreciated

Thanks
Obucdow

 

[SydneyGeek]

Let's say you have 3 fields in a query: [Cost], [MarkupPercent] and [NewCost]. [Cost] and [MarkupPercent] come from your table, the calculated field ([NewCost] or [MarkupAmt]) is part of the query.
Put your percent in the [MarkupPercent] field.
[NewCost] is a calculated field so, in first blank column in the query, put:
NewCost:Int([Cost]*(1+[MarkupPercent]))+1
If all you need is the Markup amount, do this --
MarkupAmt:Int([Cost]*[MarkupPercent])+1

Int takes only the integer portion of the number, effectively rounding down. Add 1 to round up.

Denis

 

[Andrew Fergus]

Hi, following up on the suggestion from Denis, if your cost data is already formatted with dollars and cents, try this formula to round up to the next whole cent :

Int((100*[Cost]*(1+[MarkUpPercent]))+0.99)/100

If you literally want to round the cost up by 10%, 15% and 20%, then use these 3 formulae :

Int((100*[Cost]*1.1)+0.99)/100
Int((100*[Cost]*1.15)+0.99)/100
Int((100*[Cost]*1.2)+0.99)/100

HTH, Andrew.