sbartmasser
New Member
- Joined
- Mar 19, 2010
- Messages
- 17
I am trying to set up a formula where it looks at a cell and decides if there is enough funds to transfer ..if not pull more from another place. Only transfer enough of what is needed.
See example .. if you look at line #1 there is $874K is available I want to transfer up to the amount I need in line #2 . If there is more then enough then take only what is needed.. if it is less take it all. This formula will be posted on line #3 . I am puzzled by how to set up the formula. Thank you in advance
[TABLE="width: 311"]
<colgroup><col width="23" style="width: 17pt; mso-width-source: userset; mso-width-alt: 841;"> <col width="218" style="width: 164pt; mso-width-source: userset; mso-width-alt: 7972;"> <col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl92, width: 23, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 218, bgcolor: white"] [/TD]
[TD="class: xl81, width: 21, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 25, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 126, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"]Current Ending Corp Balance[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($8,798,540.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Current Tiered Account Balance[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$874,000.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Tiered Account Balance Reserves[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: #494529"] - [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]1[/TD]
[TD="class: xl84, bgcolor: white"]Available for tranfser[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]$874,000.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]E-Services Outgoing Wire -7732027220[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($1,985,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Pending Wires- (Incoming and Outgoing)[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$0.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Share Draft Posting ..[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$0.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Daily Residual[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($1,000,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]2[/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] "]Total Transfer Needed [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"]($11,783,540.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]3[/TD]
[TD="class: xl88, bgcolor: #B1A0C7"]Total Transfer (if any) from Tiered Acct[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: #B1A0C7"] 11,783,540.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
See example .. if you look at line #1 there is $874K is available I want to transfer up to the amount I need in line #2 . If there is more then enough then take only what is needed.. if it is less take it all. This formula will be posted on line #3 . I am puzzled by how to set up the formula. Thank you in advance
[TABLE="width: 311"]
<colgroup><col width="23" style="width: 17pt; mso-width-source: userset; mso-width-alt: 841;"> <col width="218" style="width: 164pt; mso-width-source: userset; mso-width-alt: 7972;"> <col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl92, width: 23, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 218, bgcolor: white"] [/TD]
[TD="class: xl81, width: 21, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 25, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 126, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"]Current Ending Corp Balance[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($8,798,540.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Current Tiered Account Balance[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$874,000.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Tiered Account Balance Reserves[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: #494529"] - [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]1[/TD]
[TD="class: xl84, bgcolor: white"]Available for tranfser[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]$874,000.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]E-Services Outgoing Wire -7732027220[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($1,985,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Pending Wires- (Incoming and Outgoing)[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$0.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Share Draft Posting ..[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]$0.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: white"]Daily Residual[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , align: right"]($1,000,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]2[/TD]
[TD="class: xl86, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] "]Total Transfer Needed [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"]($11,783,540.00)[/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"]3[/TD]
[TD="class: xl88, bgcolor: #B1A0C7"]Total Transfer (if any) from Tiered Acct[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl89, bgcolor: #B1A0C7"] 11,783,540.00 [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]