IF statement with 3 logical tests

[wallstreetballa]

Hi everyone,

I have a really complicated logical test that i'm not sure how to set up...

I have 6 rows of numbers to analyze and 3 columns (3 columns of numbers in total). In this function i want to see if 3 conditions exist

1) I want to see if the number in column A is less than 1

2) I want to see if the numbers follow this sequence, B5<B6,B4<B5,B3<B4,B2<B2, B1>B2

3) B6 is less than C1 by .10 and B2 id less than C6 by .30

All of this in one function to spit out True or False

I know this is really busy and complicated but if anyone can help me into an IF statement I will really appreciate this!

[FDibbins]

this is a shot in the dark if it doesnt work, maybe consider uploading a sample workbook with some data and exlected outcome...

=and(A1<1,B5<B6,B4<B5,B3<B4,B2<B2, B1>B3,B6=C1*.9,B2=C6*.7)

[Tank997]

can you upload a file as an example with number to show what you need here, seems simple but it would be better to see it with the numbers.

[SDCh]

B5<B6,B4<B5,B3<B4,B2<B2, B1>B2

See the red one, it's true like that?

[wallstreetballa]

See the red one, it's true like that?

hey sorry tghat was a typo

should be B2<B3

[wallstreetballa]

this is a shot in the dark if it doesnt work, maybe consider uploading a sample workbook with some data and exlected outcome...

=and(A1<1,B5<B6,B4<B5,B3<B4,B2<B2, B1>B3,B6=C1*.9,B2=C6*.7)

Thanks a boatload for this, I really appreciate it!

It works but i'm not sure if its right or not... it gave 250 false's for the rule

i'm essentially trying to test 3 conditions in one test, i'm wondering if it might be easier to do it individually any add and compare the differences from there...

Any suggestions?

[SDCh]

IF all column A < 1 change FDibbins formula like this:

Please Login or Register  to view this content.

[wallstreetballa]

IF all column A < 1 change FDibbins formula like this:

Please Login or Register  to view this content.

This formula looks a lot more ordered. I tried it, it works but once again everythings false...

I need to try a couple variations with it

Thanks a million!!

[wallstreetballa]

just wondering...

whats the format for 3 logical tests...? I've been looking for a guide or some instruction on this

[FDibbins]

try something like...

=if(A1=B1,"XXX",if(A1=C1,"YYY","ZZZ"))

If you go more than that, I would suggest using a vlookup or index/match

[SDCh]

Can you upload example file, so anyone in here can give a better suggestions?

[wallstreetballa]

Can you upload example file, so anyone in here can give a better suggestions?

I'd love to SDch but its private information,

I'll try to upload something similar

I appreciate all of the help!

[Tank997]

wallstreetballa , we don't need to see your actual data just some made up numbers and column labels that demonstrates you're question.