How to put contradictory conditions in same cell

[Madhusoodan]

Hi,
Please guide me suitably on following:

My column A is going to have values like 1016 in A1, 503 in A2, 1004 in A3, 500 in A4 so on. In column B (in B1), I want to put both the following two
statements together.

STATEMENT ONE : A1 is greater than 1015 and lesser than 1005, if true then A1, if false then zero.)
STATEMENT TWO : A1 is greater than 502 and lesser than 500, if true then A1, if false then zero.)

Please help.

[Richard Buttrey]

How can any number be both greater than 1015 and less than 1005? Ditto with 502 & 500

Are those typos and you mean greater than 1005 and less than 1015, & > 500 <502

If that was a typo what about numbers > 1015 and > 502

[davsth]

it can be done but you need to give answers statement 1 can not be true as an and >1015 and < 1005 is impossible so is it an or? or are your signs the wrong way round?

If say the value is 501 what should be the answer? the second statement is false but the first is true

do you mean the below


if(or(and(a1<=1015, a1>=1005),and(a1<=502,a1>=500)),0,a1)

[Madhusoodan]

Thanks for picking up the type. Sorry.

[Madhusoodan]

Sorry for the incorrect posting. It was just due to oversight.
Thanks for the help. Solved my problem. Thanks a lot.

[Madhusoodan]

Hello...since last two hours I was trying to solve one more issue, following the last given guidance.
However, I couldn't solve the problem. Please help.

I want to put formula in C1 as under:
IF A1 is lesser than 91, greater than 96.8 and B1 is Zero, then D1.

[davsth]

you are back to your confusing conditions you need to state and or or in your questions

the answer for what you asked is =if(and(a1<91, a1>96.8,b1=0),d1,"") but this can not be true

perhaps if(and(or(a1<91, a1>96.8),b1=0),d1,"")

[Richard Buttrey]

...or perhaps

Please Login or Register  to view this content.

but as davsth says it all depends what you mean since the question as put is confusing.