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.
