Round a number

[mariaor]

Hello,
This forum was been most helpful. Now I have a new problem, I need to round the numbers I have on a table: if the decimals are more or equal to .8 I need to round the number to the next one, if it is less than .8, to the one before. For example:

I have I need
7.7 7
7.9 8
6.3 6
6.8 7

And so on...
Thanks!

 

[Mike Lewis]

Glad you've found the forum helpful.

Here's a possible solution:

lnRounded = CEILING(lnNumber - 0.8)

I haven't tested it, so can't guarantee anything.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[SnyAc]

alternatively....

lnRounded = round(lnNumber + .3)

also untested....

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

Hyperware Inc. a division of AmTech Software

http://www.hyperwareinc.com

 

[SnyAc]

corrected for 1 decimal

lnRounded = ROUND(lnNumber + .3, 1)

again... untested...

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

Hyperware Inc. a division of AmTech Software

http://www.hyperwareinc.com

 

[cbasoz]

Mike was close:

lnRounded = CEILING(m.lnNumber - 0.7)

Cetin Basoz
MS Foxpro MVP, MCP

 

[NasibKalsi]

Alternately

NewNumber = int(OldNumber+.2)

 

[Mike Lewis]

The choice between INT() and CEILING() depends in part on how negative numbers are to be treated (if that's relevant).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[NasibKalsi]

Hi Mike:

I did not realise the difference but you have a point.

In general, when rounding do you go to the next highest number or you go to the next ABSOLUTE highest number ?

Nasib

 

[Mike Lewis]

n general, when rounding do you go to the next highest number or you go to the next ABSOLUTE highest number ?

I don't know. I suppose it depends on the particular requirement.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[mariaor]

This is what worked for me:
Replace lnNew with iif(lnoriginal-int(original)>=0.8, int (lnoriginal)+1, int(lnoriginal))
Thanks anyway!

 

[NasibKalsi]

I wonder, if int(oldNumber+.2) failed on your data set and at what condition ?