Rectified formula neded

[hsandeep]

I am using

AFZ53=IF(AND(AFB53<>0,AFB53<$AFO53),-100,IF(AFA53>$AFN53,100,0)) but getting 100 (This is WRONG) I should get 0. What should the rectified formula be?

AFA53=FALSE
AFB53=FALSE
AFN53=2.5
AFO53=-2.5

 

[Michael M]

I'm offended...
I only drink on the days that start with "T"

Tuesday, Thursday, Today, Tomorrow, Thaturday and Thunday.....

 

[XOR LX]

 

[hsandeep]

Cannot make a direct comparison of Boolean (True\False) values to Numeric values. One way to convert Boolean to Numeric is to multiply them by 1

AFZ53=IF(AND(AFB53*1<>0,AFB53*1<$AFO53),-100,IF(AFA53*1>$AFN53,100,0))

This WORKS. Please
FALSE*1=?
TRUE*1=?

 

[AlphaFrog]

This WORKS. Please
FALSE*1=?
TRUE*1=?

FALSE*1=0
TRUE*1= 1

Put this in cells and see.
=FALSE*1
=TRUE*1