# IF/OR/AND Statement

Hi,
I have attached an IF statement i made that is failing on certain pieces of data.

I may have constructed it incorrectly

The logic of the the IF is:

IF A2= FIT or FIJ and J2 = buy, leave O2 as it is

IF A2= FIT or FIJ and J2 = sel, multiply O2*-1

IF A2 = SIT and J2 = Buy, multiply o2*-1

IF A2 = SIT and J2 = sel, leave O2 as it is

I have attached the IF below

Thanks
Seamus

test.xls
Microsoft Excel

Last Comment
Norie
Norie

The ORs are missing a cell reference.

Even if it's the same cell you are checking you still need that.

This,

OR(A1="FIJ","FIT")

should be this,

OR(A1="FIJ",A1="FIT")

That'll get rid of the #VALUE! error, don't know about the logic.:)

Use this formula...

Saurabh..
Rory Archibald

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Seamus2626

Rory squared up the logic as well as the formula, thank you all for suggestions.

Thanks
Seamus
Norie