Calculation field - rounding up and leave out value
I have a 2 questions, which I think could be quite basic.
1st question: I have a calculation field that is calculating a price, for a product based on different materials. I want to have this to always round up to the the nearest 5's... so 1-4 would = 5 and 6-9 would = 10
Tried to look into the round() function, but couldn't get it to work.
2nd. question: Is it possible to have the calculation field not show a value if one of the fields it’s calculations have no input.