HELP - Percentage Of Round Up to 25?

[mortenzo]

Hey,

looking for a quick solution.....

using $...in cell A1 I have a total. in cell B1 I need 10 percent of that total rounded up to the nearest $25

I can't see to figure out how to get the 2 formulas to talk to each other....Please and thank you.

 

[etaf]

in B1 try

=(int((A1*0.1)/25)+1)*25