Whats wrong with this formula

TiggerToo · Apr 30th, 2002, 04:20 AM

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 · Apr 30th, 2002, 04:36 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 04:20 AM	#1
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	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

Apr 30th, 2002, 04:36 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	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