i am trying to do a series of calculation i need to add dollar amounts in d5 cents in e5 then h5 dollar i5 cents then minus j5 dollar k5 cents add l5 dollar m5 cents minus n5 dollar o5 cents all formulated to total in p5 dollars q5 cents
i have the adding side of it working with this formula
=sum(d5,h5,l5)+int(sum(e5,i5,m5)/100 put in th dollar amount cells and
=right(sum(e5,i5,m5),2)*1 put in the cent cells
but i dont know how to minus j5 dollars k5 cents and n5 dollars o5
all this calculated to p5 dollar amounts q5 cents amount
excel 16 mac air
=SUM(D5,H5,L5,-J5,-N5)+INT(SUM(E5,I5,M5,-K5,-O5)/100)
=RIGHT(SUM(E5,I5,M5,-K5,-O5),2)*1
Basically, I’m doing the “subtraction” within your SUM functions by turning your subtraction values into negative numbers. After that, the rest of your original formulas take over.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03