Subtract + round

[SubBow]

Looking for a formula that will subtract B2 from A2, and then round up that result to the next 30. For example, if A2 is 308, B2 is 185, I need C2 to be 150 (308-185=123, the next 30 is 150). Thank you!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=CEILING(A2-B2,30)