excel /vba help - Substraction not working

[Mallesh23]

Hi Team,

I am trying to substract Column F value from column B.
giving me incorrect output. =F2--B2

When tried =D2--A2 gives me Correct output.

looking your help in excel formula or vba both ok. thanks

Below is a snapshot Column G gives wrong output, expected output shown in H2:H3.

Book7
	A	B	C	D	E	F	G	H
1	Outstanding Balance	Bal as per SAP		Sum Amt	Difference	Today's Balance	Difference
2	5,317.59	307.26		-5317.59	-	307.26	614.52	Expected - 0 value in G2
3	5,000.00	4,000.00		-5000	-	5,000.00	9,000.00	Expected - 1000 in G3
4
5					=D2--A2		=F2--B2
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=D2--A2
G2:G3	G2	=F2--B2

Thanks
mg

 

[FormR]

Hi, you just need one minus sign in your formula i.e.

=F2-B2

 

[Mallesh23]

Hi FormR,

I want to use same formula in both Difference Column.

if I use single minus sign, in One Difference columns formula gives correct output.
in other Column it gives wrong output.


Thanks
mg

 

[FormR]

in other Column it gives wrong output.

Hi, sorry, but that doesn't give enough information about what you want to do to be able to make a new suggestion.

 

[Mallesh23]

Hi FormR,

Thanks for looking into my query. I used the formula suggested by you.
Column E is giving incorrect value.

Below is screenshot with formula in Column E and G.

Book7
	A	B	C	D	E	F	G
1	Outstanding Balance	Bal as per SAP		Sum Amt	Difference	Today's Balance	Difference
2	5,317.59	307.26		-5317.59	-10,635.18	307.26	-
3	5,000.00	4,000.00		-5000	-10,000.00	5,000.00	1,000.00
4
5					=D2-A2		=F2-B2
6
7				Expected - 0 value in e2
8				Expected - 1000 in E3
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=D2-A2
G2:G3	G2	=F2-B2

Thanks
mg

 

[FormR]

Can't you just use your existing formula in column E?

 

[Mallesh23]

Hi FormR,

I can, But I am creating vba macro to the end user, and my next course of action depend on minus values.
So needs same logic/formula for both the columns.



Thanks
mg

 

[FormR]

But I am creating vba macro to the end user, and my next course of action depend on minus values.

It's not clear why that would make any difference but how about something like.

=A2-ABS(D2)

 

[Mallesh23]

Hi FormR,

Thanks for your help, it worked as expected.

Thanks
mg