• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Maths problem

oi oi ...EO....comeeeeeeon old chap...tell me that scribbled bit of barely pseudo code is eeeeeeeeeexactly what you're looking for :nerd
Tell me what language you're using and I might even see if I can smarten it up appropriately.
 
oi oi ...EO....comeeeeeeon old chap...tell me that scribbled bit of barely pseudo code is eeeeeeeeeexactly what you're looking for :nerd
Tell me what language you're using and I might even see if I can smarten it up appropriately.

It's VBA


I got round it by looping through the values and jiggling with the number type.
not quite as good as a dither, but it works
users say they will accept diferent numbers for the same % , so long as the bottom line is correct


public dblRoundmeUpAS double
public lngLastRoundmeUp as long

function RoundmeUp(myVal)


dblRoundmeUp = dblRoundmeUp + myVal
RoundmeUp = CLng(dblRoundmeUp) - lngLastRoundmeUp
lngLastRoundmeUp = dblRoundmeUp

end

I'm sh1t as maths me:frown




:rolleyes:
 

Advertisers

Back
Top