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