Previous Topic Next Topic

Need to add 2 amounts in one cell for excel

Closed
bubbles - Sep 19, 2010 at 10:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 20, 2010 at 09:01 AM
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
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 20, 2010 at 06:10 AM
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.
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 20, 2010 at 09:01 AM
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 (', ')
0