How to combine, IF, AND, OR Functions

[Simony32567]

Hi all

I need some help combining IF, AND, OR functions (if it is possible)

What I am looking to do is:

I want all the results to display in F70

I have F72, F73, F74 which contain the results of calculations depending on
the values in the cells above them. Any one of these cells (F72, F73, F74)
could hold a value of zero or greater.

I also have B68, B69, B70 and B71 which contain other results of
calculations depending on the cells above them, these cells will always hold
a value >1

What I want to display in F70 is that:

If there is a figure >1 in F72 AND a figure of zero in F73 then show B70
If there is a figure >1 in F73 AND a figure of zero in F72 then show B69
If there is a figure >1 in F74 then show B68
If there is a figure of zero in both F72 AND F73 then show B71

Hope this is possible.
Simoney

 

[Jacob Skaria]

Try

=IF(AND(F72>1,F73=0),B70,IF(AND(F73>1,F72=0),B69,IF(F74>1,B68,IF(F72+F73=0,B71))))

 

[Jacob Skaria]

Try

=IF(AND(F72>1,F73=0),B70,IF(AND(F73>1,F72=0),B69,IF(F74>1,B68,IF(F72+F73=0,B71))))