**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hello there,
I am trying to get a formula that is a invoice has been paid it will adjust the running total.
Example:
A1 was invoice Â£100,
B2 if it has been paid (yes/no in a dropdown box)
C2 would either show as Â£100 or Â£0.00

Solved by T. A. in 10 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
03/08/2018 - 10:31

Hello

User
03/08/2018 - 10:32

hi

Excelchat Expert
03/08/2018 - 10:32

How are you?

User
03/08/2018 - 10:32

Im good thank you how are you?

Excelchat Expert
03/08/2018 - 10:32

I am great, thank you.

User
03/08/2018 - 10:32

glad to here

Excelchat Expert
03/08/2018 - 10:32

Please tell me more on your requirement.

Excelchat Expert
03/08/2018 - 10:33

and if possible share the sheet or build a sampel data for me o nthe right

User
03/08/2018 - 10:33

Ok

User
03/08/2018 - 10:35

So if a1 was £100 and I want to use yes of no to get a running balance

User
03/08/2018 - 10:35

so if b2 says yes c1 would equal 0.00

User
03/08/2018 - 10:36

if b1 equal no would equal a1

Excelchat Expert
03/08/2018 - 10:36

=if(B1="Yes",0,A1)

Excelchat Expert
03/08/2018 - 10:36

this is the formula I have used

Excelchat Expert
03/08/2018 - 10:37

so If B1 = Yes, then show 0 otherwise A1

User
03/08/2018 - 10:37

that's fantastic

Excelchat Expert
03/08/2018 - 10:37

now to eliminate the other 0 which is coming even when there is no data in Column A

Excelchat Expert
03/08/2018 - 10:37

I will add another function to it.

Excelchat Expert
03/08/2018 - 10:38

so now the formula is modified to

Excelchat Expert
03/08/2018 - 10:38

=if(A1="","",if(B1="Yes",0,A1))

Excelchat Expert
03/08/2018 - 10:39

so now if A1 = "" means blank, it will show blank, other otherwise it will execute our old formula.

User
03/08/2018 - 10:40

I see now that's amazing

Excelchat Expert
03/08/2018 - 10:40

I hope I am able to answer your query to satisfaction.

Excelchat Expert
03/08/2018 - 10:40

If you are satisfied with my solution, please go ahead and end the session and provide good feedback so that I can keep assisting others.

User
03/08/2018 - 10:40

yes that's helped me out so much I can get my project submitted today

Excelchat Expert
03/08/2018 - 10:41

Thank you and have a great day ahead!

User
03/08/2018 - 10:41

thatnk you for your time and have a pleasant day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*