If statement - 2 tests

  • Thread starter Thread starter RobertLees
  • Start date Start date
R

RobertLees

Hi

How can I test 2 criteria to set a cell value? I think there is an
=if(or---etc, but what syntax should I use.

Thanks
Robert
 
Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--


XL2003
Regards

William
(e-mail address removed)
 
You must log in or register to reply here.

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

If Statement with Two Different Logical Test 16
IF Statements 9
Excel Need Countifs Formula Help 0
MATCH not working in IF statement 6
Ms Excel Multiple Logical Test Function 0
Return matched value 2 criteria 4
IF statement to check for numerical value 3
Access Dcount (multiple criteria) 3

Back
Top