C
crackers
I have 9 columns of data in a worksheet that varies all the time.
I have written a formula to retrieve certain lines of the data as
follows:
=IF(AND(B11>10,B11>6,B12>9<15),1,"")
The code does not work because of the 'B12' argument of picking the
line if the number is greater than 9 and less than 15.
Could someone please advise what is the correct way to write this part
of the formula.
Any help would be greatly appreciated.
I have written a formula to retrieve certain lines of the data as
follows:
=IF(AND(B11>10,B11>6,B12>9<15),1,"")
The code does not work because of the 'B12' argument of picking the
line if the number is greater than 9 and less than 15.
Could someone please advise what is the correct way to write this part
of the formula.
Any help would be greatly appreciated.