Issue with IF formula in Excel

Hi,

I need to write a formula which will check 2 conditions,

1. If one cell value is 'JE' then
2. If another cell value is not 'ARC','SPL' then
value 'TYPE' else 'OTHER'


IF(AND('Detail'!$B$3="JE",IF(NOT(OR('JE Detail'!$B$6 = "ARC",'JE Detail'!$B$6 = "SPL","",""),"TYPE","OTHER")))

This is not giving correct value as I have not given any values for NOT(OR) statement. But, I need the result to be based on B3 and B6 cells, not just B6.

Any suggestions are highly appreciated.

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Hi,

Updated the title

Change it to this, please:

"How to Correctly Use AND & OR in an IF Statement"

(change should have been done in 1st post, but no biggy - this time )

Hard to say for sure without some data to work with, but maybe...
=IF(AND('Detail'!$B$3="JE",'JE Detail'!$B$6 <> "ARC",'JE Detail'!$B$6 <>= "SPL"),"TYPE","OTHER")

Originally Posted by jtakw

Hi,

Ford, I was going to post that exact same formula for OP, but was waiting for MOD/ADMIN approval of the Title change...

OP changed the title in post 3, instead of post 1. I took that to mean compliance with Ali's request, albeit in the wrong post