If(And( >=, <= Statement

[yekut1102]

Hi everyone,

Here is my setup,
Column-A consist of values: .00, .14, .29, .43, .57, .71, .86
Column-B consist of values: .00, .04, .08, .13, .17 .21 .25 .29 .33 .38 ...continued to .96 (this pattern is represents % hour of the day, i.e. .08% =0200; .13%=0300; .17%=0400...and so on).

I'm trying to devise an 'If/And' statement whereby if Column-A is >.24 and <.87 AND Column-B is >.28 and <.87 then Column-C equals .08515, else .06549.

So far I've tried =IF(AND(A1>0.24<.87,B2>.028<.87),".08515",".06549") but
only .06549 will show even when both of the statement are true.

Could anyone spare some wisdom?
Thank you in advance!

 

[JamesW]

Hi,

Welcome to the board.

Try:

=IF(AND(A1>0.24,A1<.87,B2>.028,B2<.87),".08515",".06549")

 

[VoG]

Try

=IF(AND(A1>0.24,A1<0.87,B2>0.028,B2<0.87),0.08515,0.06549)

 

[yekut1102]

Great!
Thank you for the quick help JamesW and voG. Much appreciation!