Rounding up in increments

Good evening shanna

...and welcome to the forum!!

Originally Posted by shanna

I'm trying to create a spreadsheet where we'll be multiplying a value by x%, then I need to round up the result to the nearest 25 (ie 10*25% = 12.5, need to input formula to round this to 25).
Any suggestions (if my rambling made sense)?

Hmmmmm, 10*25% doesn't equal 12.5, but if you want to round up to increments of 25 then you could use the Ceiling function, thus :
=CEILING(A1,25)

HTH

DominicB

Originally Posted by dominicb

Good evening shanna

...and welcome to the forum!!

Hmmmmm, 10*25% doesn't equal 12.5, but if you want to round up to increments of 25 then you could use the Ceiling function, thus :
=CEILING(A1,25)

HTH

DominicB

Brain fart there. I meant 10*1.25

I'll try both of your suggestions! Thanks!

ETA, I tried both and Dominic, yours gave me what I was looking for! For a bit of background, I'm trying to populate some fields for a big fundraising appeal. I'm customizing each letter based on how much the donor had given in the past. I want to give them several levels of gift to choose from, but I want nice, even numbers. So I'm was looking to increase the last gift amount by 20%, then round it to the nearest 25 - if someone gave 35, their next giving choice would be 50.

Thanks again

Just for fun
How about this

=ROUNDUP(A1/25,0)*25