Solved: Excel IF function

[office38]

I need to pop a function in to a spreadsheet but I'm struggling, any help would be appreciated.

What I'm after is;

If G269 is between 0.251 and 1.00
Value if true = K269
Value if false = 0 (zero)

I've tried the following function that I thought would work but apparantly not;

=IF(G269>="0.251"<="1.00",K269,0)

Thank you

 

[Pat_Mc]

=IF(AND(G269>=0.251,G269<=1),K269,0))

That should work for you.

Also, if you put numbers inside "" then excel will think they are strings

 

[office38]

Thank you Pat

Perfect!

 

[Pat_Mc]

Your welcome!