Is it possible the decimals numbers rounded up to .99 for all numbers in that price list in Microsoft Excel?

Question

Ex:

From this:

1.23

4.75

2.65

To this:

1.99

4.99

2.99

Answer 1

That is not rounding, that is converting. So yo ucannot do it by default or with conditional formatting. But you can do it with a formula:

=(INT(A1)+IF(MOD(A1,1),0.99))

assuming the value is in cell A1

Answer 2

Try this

=ROUNDUP(A1, 0)-0.01

where A1 is your number

or

=ROUNDUP(1.23, 0)-0.01

=ROUNDUP(4.75, 0)-0.01

=ROUNDUP(2.65, 0)-0.01

Answer 3

if your $1.23 is in cell A1, then your formula cannot be in A1, you can put it in cell A2.  in cell A2 enter   ROUNDUP(A1, 0)-0.01, you can then drag this formula down to do the math.

you can also type =if(a1="", "", ROUNDUP(A1, 0)-0.01), this will give you a blank A2, as long as there is nothing in A1.