Forum Discussion
Adding based on conditions
Hello,
I'm trying to calculate "total owed"
total owed = 2024 balance + "Prevs amnt owed UNLESS there is a "Client estimate" in which case
total owed = Client estimate + "prevs amnt owed" see below table
this is what i have so far,
| =IF(ISBLANK(D4), SUM(C4,E4), "Needs Fix") |
it only works for those that don't have a client estimate. Any help on this is appreciated.
=E4+IF(D4="", C4, D4)
=E4+IF(D4="", C4, D4)
- Works perfectly, thanks!
