Using If statement with and/or

**perryre** · 02-13-2012, 11:07 AM

I need to create an 'if' statement that does the following...
If E2>40, and F2 is MA or CA or GA or RI then"Check State" if not leave blank ("").
Can you do an if statement with and and or in the same formula?

**twiggywales** · 02-13-2012, 11:16 AM

im no expert but i would say that this should do your task

=IF(AND(E2>40,OR(F2="MA",F2="CA",F2="GA",F2="RI")),"Check State","")

i think

**perryre** · 02-14-2012, 02:58 PM

Thanks...I had the principle but the format was wrong - this works.

**twiggywales** · 02-15-2012, 05:02 AM

glad you got it working

if a my post helped can you hit the rep button (little star shape under the user details)

Thread: Using If statement with and/or

Thread Tools

Display

Using If statement with and/or

Re: Using If statement with and/or

Re: Using If statement with and/or

Re: Using If statement with and/or

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions