Thanks:  0
Likes:  0

# Thread: Whats wrong with this formula

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

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•