I have a workbook with two tabs. The first tab is named “2015 TrialBalanace”. The second tab is named “Sheet1”. I need an Excel formula on tab 2015 TrialBalanace Cell G14 that does the following:
Tab 2015 TrialBalanace has a value on cell F2, cell A14 and cell G56 . I need a formula that adds the amounts on Sheet1 column G if Sheet1 column B is equal to 2015 TrialBalanace cell F2, If Sheet1 column F is equal to 2015 TrialBalanace cell A14, If Sheet1 column C is equal to 2015 TrialBalanace cell G56, if Sheet1 column E is equal to 6411090 then multiply Sheet1 column G times mines 1, else column G.