Hello, I am trying to get the IF function to search the table of data for values <=10 and > 0.
This is the formula I am trying to use.
=IF((F5:I5>0)*(F5:I5<=10),"Passed","Failed")
The formula will not run my test for horizontal data, it only returns #Value. I can not find any resources online to explain why an IF function can not be used horizontally.
This is the formula I am trying to use.
=IF((F5:I5>0)*(F5:I5<=10),"Passed","Failed")
The formula will not run my test for horizontal data, it only returns #Value. I can not find any resources online to explain why an IF function can not be used horizontally.