charliesnat
New Member
- Joined
- Jan 19, 2009
- Messages
- 1
I have a pricing spreadsheet from out vendors. They list the current cost and I have figured our retail according to are selected margin. But I need the retails to round up or down to the nearest .99.
Ex. 23.37 down to 22.99
5.61 up to 5.99
Can anyone help with a formula?
Ex. 23.37 down to 22.99
5.61 up to 5.99
Can anyone help with a formula?