All of my prices must be rounded up to the nearest \$0.95. I have 23.106 and 102.58888, for example. They would have to be adjusted to \$22.95 and \$102.95 respectively. How can I accomplish this using a formula or function in Excel?
Oct 9, 2022 in Others 361 views

## 1 answer to this question.

Try this:

` =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING(A3,1)+1,CEILING(A3,1))-0.05`
• 63,180 points

## How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

## How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

## How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

## How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE

## How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

## Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE