[go: up one dir, main page]
Scribd
Upload
59 views3 pages

Max Min Functions

This document shows cash flow and cash balance data for different model years. It demonstrates using the MAX and MIN functions to split cash balances into assets (using MAX) and liabilities/overdrafts (using MIN) based on whether the cash balance is positive or negative for each period. This allows presenting the cash data in a balance sheet format with positive balances as assets and negative balances as liabilities.

Uploaded by

Xie Do
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
59 views3 pages

Max Min Functions

This document shows cash flow and cash balance data for different model years. It demonstrates using the MAX and MIN functions to split cash balances into assets (using MAX) and liabilities/overdrafts (using MIN) based on whether the cash balance is positive or negative for each period. This allows presenting the cash data in a balance sheet format with positive balances as assets and negative balances as liabilities.

Uploaded by

Xie Do
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 3

MAX and MIN functions

Model year 0 1 2 3

Business cash flow (from cash flow statement) 200.0 400.0 (600.0)
Cash balance less overdraft (500.0) (300.0) 100.0 (500.0)

Cash balance (IF function) 0.0 0.0 100.0 0.0


Overdraft (IF function) (500.0) (300.0) 0.0 (500.0)

Cash balance (TRUE/ FALSE logic test) 0.0 0.0 100.0 0.0
Overdraft (TRUE/ FALSE logic test) (500.0) (300.0) 0.0 (500.0)

Cash balance (MAX function) 0.0 0.0 100.0 0.0


Overdraft (MIN function) (500.0) (300.0) 0.0 (500.0)
4 5 7 8

800.0 600.0 (700.0) 602.0


300.0 900.0 200.0 802.0

300.0 900.0 200.0 802.0 Enter into assets side of balance sheet
0.0 0.0 0.0 0.0 Enter into liabilies side of balance sheet
We have split cash balances into two using MAX and MIN functio
300.0 900.0 200.0 802.0
0.0 0.0 0.0 0.0

300.0 900.0 200.0 802.0


0.0 0.0 0.0 0.0
to two using MAX and MIN functions

You might also like