Rounding up my total price

[FindNymeria]

Hey there,

I am completely new to excel and need to be walked through instructions thoroughly

my current objective is to round up my total price (the entire column) to the nearest $.05

I've gone into the math & trig tab and attempted to set the "function arguments"

though everything I try to type in is only effecting the top cell in the column (yes the entire column is selected)

I've also tired formatting the cells, but am clearly missing something

PLZ halp!

-Kate

 

[Chrisdontm]

Would this be what you are looking for...? ( Rounding up Total price only )

Lets say that your info is in cells C4:C7, and your "SUM Total" cell is in C8
Then put this in C8:

=CEILING.MATH(SUM(C4:C7),0.05)

Now adjust the ranges as needed...

 

[FindNymeria]

Would this be what you are looking for...? ( Rounding up Total price only )

Lets say that your info is in cells C4:C7, and your "SUM Total" cell is in C8
Then put this in C8:

=CEILING.MATH(SUM(C4:C7),0.05)

Now adjust the ranges as needed...

Thank you!