Rounding

[Rhubie]

I have a formula - Round(20*(([PackPrice]/20)+5),0)/20) - this round up if over 5 and down if under



I now need to just round up - how would I change this formula to do that?

This is the actual code:

BookPrice: IIf([WBCode]="03-N0051" Or [WBCode]="03-N0061",Null,Round(20*(([PackPrice]/20)+5),0)/20)

I am trying to match the way that QuickBooks rounds -

If I don't round in either Access or QuickBooks - the numbers come out the same - 37.224

[AlexHedley]

How about

INT(x)+1

x being your formula not using Round.

http://599cd.com/tips/access/round-int-fix/

[Rhubie]

This is what I had first: It returns 37.20 in Access - In QuickBooks I have it round up to the nearest .05 - it returns 37.25

NBHalfPack: [BookPrice]-(Round(20*([BookPrice]*[PercentHalf]),0)/20)
Book Price is 39.60, PercentHalf = 6%

Then I tried:
Test: [BookPrice]-(Int(-100*([BookPrice]*[PercentHalf]))/-100)
It returned 37.22

Then I tried yours:

Test: [BookPrice]-Int([BookPrice]*[PercentHalf])+1
It returns 38.60

I need to have Access round up the same as QuickBooks.

[AlexHedley]

[BookPrice]-(Round(([BookPrice]*[PercentHalf]),1))+0.05

Also add an IIF to check the round is <5 or >=5 then add 0.05