M17 = 40,000

  • Thread starter Thread starter Yosemite
  • Start date Start date
Y

Yosemite

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
 
one way:

I'll assume that M17's formula is

=M14-M15-M16

If that's the case then:

M16: =M14-M15-40000
 
hi Yosemite

for me it looks like a balance sheet of amounts where M15 and M16 are
negative amounts, formatted to show as deductions....
so i guess
M16 = -(M14+M15-40000)

regards
 
oops...M15 "-amount may change" in case M16 becomes positive

maybe another way will be
=if(-(M14+M15-40000)>0,"Cannot balance see M15",-(M14+M15-40000))
 
Back
Top