Hi,
Is it possible to modify the following AND formula to suit a range rather than a static value of 0.5
Ideally within the range of 0.5 and 0.7
The formula I have is
=AND($L7<>"",$L7>0.5)
Many Thanks
Is it possible to modify the following AND formula to suit a range rather than a static value of 0.5
Ideally within the range of 0.5 and 0.7
The formula I have is
=AND($L7<>"",$L7>0.5)
Many Thanks