Multiple conditions not working in OR formula

Hey Y'all

I am having problems getting the formula I am using to consider all the values of K3. when 1 account # is used, I have no problem.

GAP REQD

Please Login or Register  to view this content.

AMT REQD

Please Login or Register  to view this content.

I HAVE ALSO TRIED THE FOLLOW FOR GAP REQD:

Please Login or Register  to view this content.

I am looking to do the following:

GAP REQUIRED
IF ACCOUNT # (K3) = 2301 2303 2304 2305 OR 6900
IS TRUE AND IF LKFCA (M13) + 5000 IS LESS THAN REQUIRED CVG (M10) = YES, (IF FALSE = N/A)
IS FALSE AND IF LKFCA (M13) IS LESS THAN REQUIRED CVG (M10) = YES, IF FALSE = N/A

AMOUNT REQUIRED
IF ACCOUNT # (K3) = 2301 2303 2304 2305 OR 6900
IS TRUE AND GAP REQD = N/A = NOTHING
IS FALSE REQD CVG (M10) - LKFCA (M13)

I have tried different ways of nesting the formulas, I have tried interchanging and and or, I have tried with 2 account #'s... I am at a complete loss and would appreciate any assistance.


http://www.excelforum.com/attachment...1&d=1465238017

I think OR is the way to go.
And each argument (separated by commas) of the OR needs to be a complete/separate expression

OR(K3=2301,K3=2303,K3=2304,K3=2305,K3=6900)

There's a shortcut method that works like this
OR(K3={2301,2303,2304,2305,6900})

Hi
Try this in G30

Formula:

Please Login or Register  to view this content.

Proceed in the same way for the other formulas.

I feel silly,

Everyone's suggestion worked, thank y'all so much!

You're welcome.