Excel functions


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 :)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel "" in function 4
EXCEL FUNCTION IF 1
Excel Function 4
Excel Function???? 4
Function in Excell 3
Excel Functions 4
Excel Functions 3
Excel Functions 3

Top