new excel problem

[fsuchef45]

Ok new problem...................... P9is the answer cell.......=P11/B3.............P11 =a sum of $4.113 and B3= a sum of 10 with P9 having a end result of $0.4113 seeing how this is money costing I need P9 to round up to become $0.42 thus rounding up to the next cent

[B Rubble]

Try using the Ceiling command. if you have 0.4113 as the answer =CEILING(0.4113,0.01) will give you 0.42 as a cell answer.

Hope this helps

[fsuchef45]

hey, thanks, B Rubble I fig it with a roundup comand , would yours do the same thing, sounds like a celing would only let the answer cell go to a set limit. thanks again