Lower data in column B to allowable max, and make offsetting change in column A

[mingold]

I have an excel spreadsheet that I need everything over a specific number to transfers over to Column A. For example, anything over the number 4.5 in Column B would transfer to Column A. So if I type the number 5.5 in Column B and Column A had the number 10 in it than Column B would reduce to 4.5 and A would increase to 11.

Is this possible?

[TMS]

Is this possible?

Not with a formula. You'd need VBA to do what you describe.

Is that an option you would be ok with?

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[6StringJazzer]

Administrator's note: Please take the time to review our guidelines. There aren't many, and they are all important. Guideline #1 recommends good titles. I have updated it for you this time because you are a new member. --6StringJazzer