Hi,

I am trying to create a function but not sure how.

M14 = 250,000 + (amount will change daily)
M15 = 200,000 - (amount may change)
M16 = xxxx -
_____________________________________
M17 = 40,000 (Must always total $40,000)


What would I put in M16 so that M17 will always total $40,000?

Any help would be greatly appreciated.

Thanks!

Yosemite