need to add 2 amounts in one cell for excel Closed

Question

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

venkat1926 · Answer

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.

rizvisa1 · Answer

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 (', ')

Need to add 2 amounts in one cell for excel

2 responses

Similar discussions

Subscribe To Our Newsletter!