one way:

I'll assume that M17's formula is

=M14-M15-M16

If that's the case then:

M16: =M14-M15-40000


In article ,
"Yosemite" wrote:

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