Round Up

abee4life

Active Member
Joined
Jan 27, 2005
Messages
319
couple of questions:

1) can someone please give me a formula that can change a number that ends in 1-9 to 0, but being rounded up!

i.e. i have number 18, but i need it rounded UP to 20.

2) i need a formula that can increase a figure to 500.. If any number, after calculations, is lower than 500, i need it increased to 500.

please help
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,009
Members
412,304
Latest member
citrus
Top