Multiple Options

[sbartmasser]

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

	Current Ending Corp Balance			($8,798,540.00)
	Current Tiered Account Balance			$874,000.00
	Tiered Account Balance Reserves			-
1	Available for tranfser			$874,000.00
	E-Services Outgoing Wire -7732027220			($1,985,000.00)
	Pending Wires- (Incoming and Outgoing)			$0.00
	Share Draft Posting ..			$0.00
	Daily Residual			($1,000,000.00)
2	Total Transfer Needed			($11,783,540.00)
3	Total Transfer (if any) from Tiered Acct			11,783,540.00

<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> </tbody>

 

[Eric W]

I'm a bit confused on your layout. You say you have 874K available, and you want 11,783,540, but the answer you have is 11,783,540. Shouldn't it be 874K? If so, then maybe just this:

tr>

	A	B	C	D	E
1		Current Ending Corp Balance			($8,798,540.00)
2
3		Current Tiered Account Balance			$874,000.00
4		Tiered Account B alance Reserves			-
5	1	Available for tranfser			$874,000.00
6
7		E-Services Outgoing Wire -7732027220			($1,985,000.00)
8
9		Pending Wires- (Incoming and Outgoing)			$0.00
10
1 1		Share Draft Posting ..			$0.00
12
13		Daily Residual			($1,000,000.00)
14
15	2	Total Transfer Needed			($11,783,540.00)
16
17	3	Total Transfer (if any) from Tiered Acct			874,000.00

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula E17 =MIN(E5,-E15) <tbody> </tbody>

<tbody>
</tbody>

Assuming I got the signs right.

 

[sbartmasser]

Thanks Eric,

I have never used MIN and it worked like a charm. Thanks for teaching me something new. I was making it much too complicated. Cheere

 

[Eric W]

Sometimes it takes some experience to see the obvious!

Glad it works for you!