Forum Discussion

LisaMarie1981's avatar
LisaMarie1981
Brass Contributor
Dec 19, 2023
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...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Dec 19, 2023

LisaMarie1981 

You can modify your formula to include the budgeted revenue if both the actual revenue and certain expenses are blank. Here is the updated formula:

=IF(AND(C6="",C8<>"",C9<>""),C4+C5-C7-C9,IF(C8<>"",C4+C5-C8-C9,IF(C8="",C4+C6-C7-C9,"")))

This formula checks three conditions:

  1. If the actual revenue (C6) is blank, the budgeted revenue (C5) is considered.
  2. If the actual expenses (C8) are not blank, it subtracts them from the calculation.
  3. If the certain expenses (C9) are not blank, it subtracts them from the calculation.

Copy this formula to your "Ending Cash Balance" cell (assuming it's in C10 in your example), and it should give you the desired result. This formula first checks for actual revenue, and if it's blank, it considers the budgeted revenue. Then, it adjusts the calculation based on the presence of actual and certain expenses. The text was revised with the AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.