ExcelBanter - IF Statement Help please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Statement Help please (https://www.excelbanter.com/excel-worksheet-functions/53375-if-statement-help-please.html)

mark

IF Statement Help please

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

Ron Coderre

IF Statement Help please

Try something like this:
=IF(OR(A1<18.44,A120),"FAIL","Pass")

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron

"mark" wrote:

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

mark

IF Statement Help please

thanks works great!!!!

"Ron Coderre" wrote:

Try something like this:
=IF(OR(A1<18.44,A120),"FAIL","Pass")

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron

"mark" wrote:

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

All times are GMT +1. The time now is 03:48 PM.