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
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