PDA

View Full Version : Rounding numbers and something else

Pajoooo
Oct 16, 2010, 04:23 PM
Help please,
View Image,

http://www.pttbn.com/media/downloads/1.png

Thanks
JBeaucaire
Oct 17, 2010, 12:37 AM
Try this:

=IF(A19<=10000, A19, MOD(A19,1000) + 9000)
Pajoooo
Oct 17, 2010, 02:52 AM
What to say? Man is a genius.

Thanks.