Need to add 2 amounts in one cell for excel

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Im trying to add 2 amounts in one cell and have another amount subtracted from that total.
for example

Column A l Column B l Column C

1,000.00, 600.54 l 1,200.00 l 400.54

Column C = 1,000.00 + 600.54 - 1,200.00.

Would this be possible??

if this is any help i have this formula and it works just not with decimals.

=IF(A1=(""""),(""""),(LEFT(A1)+RIGHT(A1)))-B1

Thank you

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
you cannot have a formula in cell using the same cell which gives an error due to ciruculr reference . what you can do is
in D1 type a formula
=A1+B1-C1
then copy D1. now select C1 . click edit -pastespecial-vlaues -ok

clear D1.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Try this

=IF(AND(A1="", B1=""),"",IF(A1="",0,IF(ISERROR(FIND(", ",A1,1)),A1,LEFT(A1,FIND(", ",A1,1)-1)+MID(A1,FIND(", ",A1,1)+2,LEN(A1)))) - IF(B1="",0, B1))

It is based on assumption, if A cell has two values (1,000.00, 600.54 ), then the values are separated by a comma and a space (', ')