Forum Discussion
Solved
IF 2 cells meet criteria
Hi there, In the below chart (text is in column A, $$ in column C). I need a formula in Ending cash balance Current formula is =IF(C8<1,C4+C6-C7-C9,C4+C6-C8-C9). So if there is nothing in actua...
When there is actual expenses it works, but when there is only budgeted it doesn't count the budgeted revenue. See below it gives 97000 as ending cash balance but in this case it should be accounting for the 5000 budgeted revenue and therefor should result in 102000 not 97000
Starting Cash Balance $100,000.00
Total Budgeted Revenue $5,000.00
Total Actual Revenue $-
Total Certainli Only Expenses Budgeted $2,000.00
Total Certainli Only Expenses Actual
Total Paid to CRDCI $1,000.00
Ending Cash Balance $97,000.00
Starting Cash Balance $100,000.00
Total Budgeted Revenue $5,000.00
Total Actual Revenue $-
Total Certainli Only Expenses Budgeted $2,000.00
Total Certainli Only Expenses Actual
Total Paid to CRDCI $1,000.00
Ending Cash Balance $97,000.00