by codis » Sat Sep 03, 2016 10:49 pm
Hi folks,
i have the cell Y5 that contains BSP and currently my trigger fires if BSP is equal to or more than 2.02
IF(AND($Z$2="In Play",$AA$1>5,T5="",Y5>=2.02)
It works fine but trying to adjust so that it fires when BSP is between equal to or more than 2.02, and equal to or less than 10.00
Does this make sense?
IF(AND($Z$2="In Play",$AA$1>5,T5="",Y5<=10.00,Y5>=2.02)
Thank you,
Alex