Chat Room Article Base Facebook Page Twitter RSS Feed
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 23, 2012, 10:44:04 AM

Login with username, password and session length
Search:     Advanced search
The E-commerce forum, the best place for advice for your Small Business.
12786 Posts in 1519 Topics by 6454 Members
Latest Member: miumiubi
* Home Help Search Login Register
+  E-commerce forum
|-+  E-commerce
| |-+  Shopping cart software
| | |-+  Zen cart
| | | |-+  Rounding Up Prices		 « previous next »
Pages: [1] Print
Author Topic: Rounding Up Prices  (Read 176 times)
Bri
Settling In
**

Karma: 0
Offline Offline

Posts: 63
« on: August 23, 2011, 03:09:35 PM »
Is there an easy way to round up the pence in all products to .99?
Logged
Bri
Settling In
**

Karma: 0
Offline Offline

Posts: 63
« Reply #1 on: August 23, 2011, 03:53:47 PM »
OK I've got an excel formula to do this in csv before I upload to zen

spreadsheet cell a1 contains £22.68

in cell b1 enter =CEILING(A1,1)-0.01

in the brackets, A1 is referenced, then rounded up to the nearest £1 then take away the penny outside of the brackets.


Hope others find this useful or am I ten years behind you lot  lol
Logged
Bri
Settling In
**

Karma: 0
Offline Offline

Posts: 63
« Reply #2 on: August 23, 2011, 04:29:33 PM »
To round down prices, replace =Ceiling with =FLOOR, same principles apply
Logged
Pages: [1] Print 
« previous next »
Jump to:  


Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!
SimplePortal 2.2.2 © 2008-2009