hi, I am trying to sort out a problem in excel.
what i am trying to do is 2 IF functions in one cell. one side will have my purchases and the other will have my sales.
=if(m17="","",-sum(m17+q17),if(n17="","",sum(n17)-sum(o17+p17))))
purchases:
m17 = 7.99
q17 = 0.36
sales:
n17 = 14.95
fees:
o17 = 1.50
p17 = 0.71
i am trying to put this into one cell and have a running total at the end.
can you help me please?
Solved by Z. J. in 14 mins