98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Nested fuctions
Nested fuctions
Resolved · Urgent Priority · Version 2003
Jaswinder has attended:
Excel Intermediate course
Excel Advanced course
Nested fuctions
I was learning to do some nested functions and was applying this to a scenario, whereby I have intercompany balances which could be either Debit or Credit balances analysed by either a "UK" or an overseas company (see attached spreadsheet).The overseas I have called "other". I wanted to get a function that would be able to get me the UK Debtor (postive) balances and UK Creditor balance (Negative) balances. Similarly i wanted the formula to give me the Other Debtor and Other Creditor balances. I wanted the formula/funtion in the area highlighted in the colour "Green".
I have tried using the "SUMIF" Function usinf the ">0" and the <0 as a criteria but can only get an answer for the overall debtor or creditor but not segregate between UK and Other. I thing I nesting another function in the "SUMIF" function could get me the result but I am struggling a bit (maybe the combination of the vlookup and sumif!!
Can you please help?
RE: Nested fuctions
Hi Jaswinder
Thanks for your question
Unfortunately you can't attach files to forum posts. If you email the file to me I will take a look at it
my email is sw@stl-training.co.uk
Thanks
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |