if(and...problem

[bluepenink]

hello

having a problem with the if(and formula, can someone pls help me with the logic!

=IF((D53=$E$53),"-",IF(AND(D53=$E$53,D46>D53),D53-D46,D46-D53))

it works fine, however, when

D53 > D46, i want it to D53-D46

the current formula that i have, is making the answer negative. the formula above works fine when D53 <D46, but when D53 > D46, it makes the value negative....can someone pls help!

thx u so much

basically, i want the formula to be as is, but when
D53 > D46, i want it to D53-D46

 

[Marcelo Branco]

Maybe something like

=IF((D53=$E$53),"-",IF(AND(D53=$E$53,D46>D53),D46-D53,MAX(D46,D53)-MIN(D46,D53))

HTH

M.

 

[bluepenink]

omg thxs alot...was beating my head on this one.

thx u so much!!!!

 

[Marcelo Branco]

omg thxs alot...was beating my head on this one.

thx u so much!!!!

You are welcome. Glad to help

M.

 

[Aladin Akyurek]

hello

having a problem with the if(and formula, can someone pls help me with the logic!

=IF((D53=$E$53),"-",IF(AND(D53=$E$53,D46>D53),D53-D46,D46-D53))

it works fine, however, when

D53 > D46, i want it to D53-D46

the current formula that i have, is making the answer negative. the formula above works fine when D53 <D46, D53 when but>D46, it makes the value negative....can someone pls help!

thx u so much

basically, i want the formula to be as is, but when
D53 > D46, i want it to D53-D46

Maybe something like

=IF((D53=$E$53),"-",IF(AND(D53=$E$53,D46>D53),D46-D53,MAX(D46,D53)-MIN(D46,D53))

HTH

M.

Marcelo,

The OP's AND bit can never evaluate to TRUE...

It appears that the following expresses the same thing:

=IF(D53=$E$53,"-",ABS(D53-D46))

Or with more caution...

=IF(COUNT(D53:E53)=2,IF(D53=$E$53,"-",ABS(D53-D46)),"")

 

[Michael M]

duplicate post
http://www.mrexcel.com/forum/showthread.php?t=570243

 

[Marcelo Branco]

Marcelo,

The OP's AND bit can never evaluate to TRUE...

It appears that the following expresses the same thing:

=IF(D53=$E$53,"-",ABS(D53-D46))

Or with more caution...

=IF(COUNT(D53:E53)=2,IF(D53=$E$53,"-",ABS(D53-D46)),"")

Oh.. you are right!

I didnt notice that there was the same condition

D3=$E$53

outside the AND (as the first IF condition)

As the OP said the formula was working ok... i overlooked this.

That said:

jw01,

think about what your original formula is doing, and try to tell us what you are trying to do.

M.

 

[Marcelo Branco]

duplicate post
http://www.mrexcel.com/forum/showthread.php?t=570243

Michael,

I hadnt seen your post...

Bad...

M.