IF Statement Help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write an If statement for the following example:

If number is <18.44 write "FAIL", If Number >20.44 Write "FAIL", If Number
is between 18.44 and 20.44 then write "Pass"

I would appreciate any help on this, thanks Mark
 
Try something like this:
=IF(OR(A1<18.44,A1>20),"FAIL","Pass")

Does that help?

••••••••••
Regards,
Ron
 
thanks works great!!!!

Ron Coderre said:
Try something like this:
=IF(OR(A1<18.44,A1>20),"FAIL","Pass")

Does that help?

••••••••••
Regards,
Ron
Click to expand...
 
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

comparing data 1
Newbee 12
IF Statement using several columns 3
if statement for number of digits 5
IF STATEMENT 19
If,Then Statement 1
Conditional Formatting based on active Named Range; IF Function to VBA 1
somewhat complex if statement help PLEASE!!!! 1

Back
Top