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
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