Multi Parameter IF Statement

Good Morning All

I was wondering if anyone can assist me, I have set up a multi parameter IF statement (Shown below) which is based on selections from two different cells to give different outcomes based on the selections there in, but I keep getting errors

Any thoughts or help would be appreciated

PHP Code: 

=IF(OR(AND($B$5="Above",$B$7="Yes",B9+1),AND($B$5="Above",$B$7="No",B9+3),AND($B$5="Below",B9+1,$B$7="Yes",B9+1),AND($B$5="Below",$B$7="No",B9+2)),1,0) 


Thanks
CraigieL

Thank you - it now returns a zero, what I would like it to do is based on the selections carry out the calculation - I may be going about it the wron way
?

Originally Posted by oeldere

You get better help if you show is the excel file, without confidentional information.

Please also add the desired (expected) result.

Hi Oeldere

I have attached an extract from the file I want to apply this IF "set " to.

The formula is contained in cell B5

Based on the selections in B1 & B2 I want to calculate out (as per calculationsin cell B5) from date in cell B4

Test File.xls

Fantastic - thank you for the help

Good Afternoon

In relation to the above thread I have created a further staement which I can't seem to combine

It is based on two seperate selections and the formula is contained below

the test file has been updated to include the selections detailed in the formula below (cell B5)

Please Login or Register  to view this content.

Can you help ?

Many Thanks