Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement
I'm looking at a spreadsheet that has 3 columns:
A: Name B: Expense 1 C: Expense 2 I have a maximum amount, $1,000, that I can spend on both expenses, but, it's important to pay all of expense 1 before starting to paying expense 2. For example, Row 1= $900 (cell B1) for expense 1 and $200 (cell C2) for expense 2. I have to pay $900 for expense 1, but only pay $100 to expense 2. Essentially, I'd like to do this with excel (probably with an IF statement): Column D - reflects the $900 amount was paid for expense 1 Column E - reflects the $100 amount was paid for expense 2 Column F -reflects that $100 is still left to be paid based on the maximum spending amount of $1,000. If you have any ideas, I'd appreciate your help! Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement
Liz J wrote:
I'm looking at a spreadsheet that has 3 columns: A: Name B: Expense 1 C: Expense 2 I have a maximum amount, $1,000, that I can spend on both expenses, but, it's important to pay all of expense 1 before starting to paying expense 2. For example, Row 1= $900 (cell B1) for expense 1 and $200 (cell C2) for expense 2. I have to pay $900 for expense 1, but only pay $100 to expense 2. Essentially, I'd like to do this with excel (probably with an IF statement): Column D - reflects the $900 amount was paid for expense 1 Column E - reflects the $100 amount was paid for expense 2 Column F -reflects that $100 is still left to be paid based on the maximum spending amount of $1,000. If you have any ideas, I'd appreciate your help! Thank you! Maybe this: B1 =900 C1 =200 D1 =MIN(1000,B1) E1 =MIN(1000-D1,C1) F1 =SUM(B1:C1)-SUM(D1:E1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |