ceiling.math rounding up 0 to next/nearest 25

cjorgens

New Member
Joined
May 18, 2018
Messages
1
I'm using ceiling.math to roundup value to nearest 25, but it will not adjust a value of 0 upwards. How do I do this? I don't want any value less than 25.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,643
You could use something like this to account for the zero values:

=MAX(25,CEILING.MATH(A1,25))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,293
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top