M17 = 40,000
 

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

M17 = 40,000
 

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

M17 = 40,000
 

--
*****
birds of the same feather flock together..



"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

M17 = 40,000
 

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
--
*****
birds of the same feather flock together..



"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

M17 = 40,000
 

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))
--
*****
birds of the same feather flock together..



"driller" wrote:

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
--
*****
birds of the same feather flock together..



"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