- Joined
- Jun 13, 2015
- Messages
- 1
- Reaction score
- 0
#Microsoft Excel
I want to check a condition, where a group of values (A1: D3) are compared to a single value(50). if #each value (A1,B1,C1,D1) satisfy the condition(>=50) then print True else False.
=IF(AND((A3: D3)>=50),"R","NR")
But the above formula does not work.
Help plz
I want to check a condition, where a group of values (A1: D3) are compared to a single value(50). if #each value (A1,B1,C1,D1) satisfy the condition(>=50) then print True else False.
=IF(AND((A3: D3)>=50),"R","NR")
But the above formula does not work.
Help plz