Sanju
Reputation: 1
Value error while using AND function in Excel
In AND function i have passed the cell ranges like this: AND(A10:A12>9,B10:B12<45) but shows an error. Please help me with this And the all values in the cells are numbers.
Upvotes: 0
Views: 62
Answers (1)
Harun24hr
Reputation: 36965
AND() function doesn't support array input. Instead, use below function.
=(A10:A12>9)*(B10:B12<45)
Upvotes: 0
Related Questions
- If(AND) combination produces "You've entered too many arguments for this function" error
- And function in google sheets not working with complex funtions
- Getting error in If condition if I use 'AND'
- Problem with result of a IF - AND function
- AND Formula not working as expected - EXCEL
- combining IF and AND statement not working in excel
- multiple if/and statement returning #value! error
- using AND condtion in vba
- Excel IF AND statement does not work
- Error using OR function in Excel