Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A mysterious if function to return a specific balance?
Hello everyone, If A1=Debit; B1= Credit; C1= Sold A2=100; A5=50; A7=10 B3= 20; B4= 50; B6= 40; B8=40 C2=A2; C3=C2+A3-B3; C4=C3+A4-B4; C5=C4+A5-B5; C6= C5+A6-B6; C7=C6+A7-B7 I need: 1) A formula in D3 and to be able to copy it down all along my transactions, that calculates the remaining sold to be consumed from the first Debit, but if the first debit was totally consumed, it shall diminish the difference from the second debit entry and so on .. 2) A formula in E3 to return the cell reference of the Debit that D3 refers to. Conclusion: Given the data ahead the results should come as follows: D3= 80 E3=A2 means there still 80 from A2 value to consume it totally. D4= 30 E4=A2 means there still 30 from A2 value to consume it totally. D6= 40 E6=A5 means there still 40 from A5 value to consume it totally (and definitely A2 value was totally consumed since 30 out of the 40 of B6 cleared the first 100, and so on .. Thank you for your support -- hankach |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to add a set amount to a balance on a specific date | Excel Worksheet Functions | |||
What function do I use to return a certain value for specific text | Excel Discussion (Misc queries) | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) |