nested fuctions

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested fuctions

Nested fuctions

resolvedResolved · 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


 

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips


Server loaded in 0.08 secs.