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

Try

=IF(AND(F721,F73=0),B70,IF(AND(F731,F72=0),B69,I F(F741,B68,IF(F72+F73=0,B71))))
--
If this post helps click Yes
---------------
Jacob Skaria


"Simony32567" wrote:

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

Simony32567;349640 Wrote:
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

Possible, no doubt
but the important thing to know is the order in which your conditions
should be satisfied, especially for F74.
Is the order the one you indicated?


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97806