Whats wrong with this formula

[TiggerToo]

column A is a date formula $f2+1
column c is a code number 31 or 32
column D is the results I need.
the formula is something like this;
=if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)
I need to check column A and B before I get the results of column D. Also when I input the formula is show something wrong with f2+1
or the +1 part of F2
Thanks Walt

 

[Aladin Akyurek]

column A is a date formula $f2+1
column c is a code number 31 or 32
column D is the results I need.
the formula is something like this;
=if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)
I need to check column A and B before I get the results of column D. Also when I input the formula is show something wrong with f2+1
or the +1 part of F2

Walt

=if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)

means that when the condition [ sheet01!a6=f2+1 ] is true, return the result of the test whether sheet01!c6 is equal to 31, an evaluation that is bound to return either TRUE or FALSE, otherwise [that's, condition sheet01!a6=f2+1 is false ] return the value in sheet01!e6. Is this your intent?

Regarding F2, type in empty cell

=ISNUMBER(F2)

and report back what this gives?

Aladin