Help, I did not explain it right last time

[TiggerToo]

=if(a6=f2,and(c6=31,or(c6=33,----> this is the problem-- if it is c6=33 I want "H" to show and if it is c6=31 I want what ever e6 is. I did have a formula like.

if(b6=31,e6,if(b6=33,"H") and if nothing showing and blank.

Walter

=IF(AND(A6=F2,B6=31),D6,0)

which is not to be entered in A6, B6, or D6.

The formula says: When both subconditions (that is, the value in A6 being equal to the value in F2 plus the value in B6 being equal to 31) are true then the value which must appear in the cell of this formula must be the value in D6; Otherwise, when either one or both of the subconstions are false, the value which must appear in the cell of this formula must be 0.

I will explain more, this is the formula I B

if(a6=31,e6,if(c6=33,"H")

But I want the formula to be something like this:

=if(a6=f2+1,and c6=31,e6,if(a6=f2+1, and c6=33,"H","")

=if(c6=31,e6,if(c6=33,"H","")

I will explain alot more,
if a6=f2+1 and if b6=31 I want to results of e6
if a6=f2+1 and if b6=33 I want "H" be the results instead of e6.
The rest of the formula is:
if the results is other than 31 or 33 I want the cell to be blank.

This formula is on a different page so that I can total what is in D6 on other pages.

[Asala42]

Hey - I'll take a shot.

Are you looking for something like this:

=IF(AND(A6=F2+1,C6=31),E6,IF(AND(A6=F2+1,C6=33),"H",""))

Adam