View Single Post
  #7   Report Post  
Old November 15th 18, 03:52 PM
markobenda markobenda is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2018
Posts: 1
Default Round a price/number to end 90 or 900

Hello. Im trying to use Round function to round prices to end 900. I have 5 or 6 digit numbers without decimal ie ( 23450, 234500). When trying to use formula: =ROUND(AF2,0)-0.01 excel give me an error:

Not trying to type a formula?

When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

you type: '=1+1, cell shows: =1+1

I need help with this formula. Tried all options.

Thank you

Marko