Set Round

how can i set excel to round up to a specified number?

for reasons both boring and rubbish, i need to get the computer to round up numbers only to certain decimals. Te decimals are x.25, x.5 and x.75. However, when it goes above x.75 it is round to the nearest whole number. For example, when I ask excel to change a 3.5 value up by 0.5 I want it to round up to the next acceptable value, which in this example would be 4.25, but it is coming up with 4.0. Help!

I’m not sure you are going to get what you want without some more of the “boring and rubbish”, but here is my best attempt based on what you explained… maybe it will at least nudge you in the right direction

=IF(CEILING(A1, 0.25)=CEILING(A1, 1),CEILING(A1,1)+0.25,CEILING(A1, 0.25))

Pyrex 6021224 Storage 10-Piece Set, Clear with Blue Lids $14.49 There are several reasons to choose glass storage containers: Pyrex glass doesn’t warp, stain, absorb odors or interact with food, it is safe for microwave and oven use, it’s attractive enough to bring to the table for casual meals. Last but not least you can see the leftovers without opening the lid, which means you won’t accidentally grab a dish of corn niblets for lunch when you really wanted t…

Lodge Logic Skillet $59.99 The Lodge 10 1/4-inch Skillet was rated as one of the two dozen essential tools in the home and kitchen (Martha Stewart Living February 2008). We have a size and shape to meet any of your cooking needs, with assist handles for ease of movement on the stove top, in the oven or on the campfire. There are more expensive skillets on the market, but none can match the versatility, durability, and value…

OXO Good Grips Multi-Purpose Pastry Scraper/Chopper $5.95 Designed to scrape and split bread dough as you work with it on a board, this tool has an extra comfy handle….

Pokemon – Round One (Vol. 25) [VHS] $7.60 As the second TV season approaches it climax, Ash Ketcham has advanced to the Pokémon League Tournament at Indigo Stadium, the Pokémon Trainer’s equivalent of Wimbeldon. Ash has to contend with the overconfidence and occasional thoughtlessness that have dogged him throughout the series. During his first matches, Misty and Brock coach from the sidelines–when Brock isn’t too busy chasing every pr…

The Lotte Berk Method: Basic Essentials, High Round Assets, Hip Hugger Abs, Muscle Eats Fat [VHS] $49.95 The Lotte Berk Method has been called the ultimate body transformation system. For over three decades this no-nonsense, results oriented fitness method has been available exclusively at Lotte Berk Method studios in Manhattan and Bridgehampton, New York. A best-selling book and hundreds of articles have featured and praised these special exercises, but now for the very first time, the world famous…

A to Z With Barney/Howdy Friends [VHS] $9.95 The title film in this two-pack set provides a fresh take on learning the alphabet, starring the perennially favorite Purple Wonder. The show is set in an after-school learning center, where Linda and friends are reviewing the letters A to Z as Barney magically appears to energize the lessons. As Barney oozes with enthusiasm, viewers will build their letter-recognition skills with a Name That Let…

Smith’s PP1 Pocket Pal Multifunction Sharpener $6.09 Smiths PP1 Smiths Pocket PAL Manual Knife Sharpener for Plain and Serrated Edge Knife Blades….

Fulcrum 3 LED 3-Pack Tap Lights $5.85 Fulcrum 3 Pack Stick On Light – Fulcrum 30010-301….

D-Con 00027 Ultra Set Covered Snap Mouse Trap $3.01 Ultra Set covered mouse trap is for those who like the effectiveness of a snap trap, but don’t like setting the snap mechanism or seeing the mouse after it is caught. This trap is easy to bait, set, and empty. Design reduces the chance of contacting the mouse or the snap mechanism itself. Reusable. Packed 1 per hang up box….

Dragon Ball: Season One $16.99 In 1986, the animated adaptation of Akira Toriyama’s manga Dragon Ball debuted on Japanese television, launching one of the most popular franchises in anime history. Dragon Ball introduced a special mixture of male bonding, rigorous training, martial arts fighting, slapstick comedy, and sci-fi action that scored a huge hit with boys and led to the follow-ups Dragon Ball Z and Dragon Ball GT–and n…