Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|