Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Adding based on conditions

Copper Contributor

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

UserName3000_0-1701033857181.png

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. 

2 Replies
best response confirmed by UserName3000 (Copper Contributor)
Solution

@UserName3000 

=E4+IF(D4="", C4, D4)

Works perfectly, thanks!
1 best response

Accepted Solutions
best response confirmed by UserName3000 (Copper Contributor)
Solution