# Display true false with IF formula

1. ## Display true false with IF formula

I am trying to get a true/false value from an "IF" formula...
I think I'm doing something wrong or missing something.

What I have is - I need cells "C3" and "E3" to have certain values in them so that when they both have the correct value they return a value from "L3" and if either or both of the cells don't have the correct value it returns a "0" value.

Any help on this would be appreciated.

2. ## Re: Display true false with IF formula

Hello & Welcome to the Forum,

Something like...

=IF(AND(C3=5,E3=10),L3,0)

3. ## Re: Display true false with IF formula

Thanks Jeff,

Now the big question for you is can I use the same principle to get a False value?
If "C3" and "L3" have two correct values I get a True, But if "C3" has a different value and "E3" has the correct value I need to be able to get the value from "L3".

Example: I have "C3" that has a marker in it "I", and "E3" has a month (Jan) in it, I need the value from "L3" to show in "BF3" - But if "C3" has a different marker (not "I") in it and "E3" has the same month (Jan) in it, I need "AS3" to have the value from "L3" in it and the value in "BF3" is False. (Which your previous answer corrected)

4. ## Re: Display true false with IF formula

Could you post a sample workbook with the different scenarios?

5. ## Re: Display true false with IF formula

Jeff,

Here is a rough idea of what I'm working with.
The first set of "Months" is for Expenses, and the second set of "Months" is for Income.

Thanks,
Bob

6. ## Re: Display true false with IF formula

Hi Bob,

Sorry, last night I was too tired to think straight. It seems this should work for you in AS3...

=IF(AND(C3<>"I",E3="January"),L3,0)

7. ## Re: Display true false with IF formula

Jeff,

Thank you sir.
That did the trick.
The help is much appreciated.

Bob

8. ## Re: Display true false with IF formula

Hi Bob,

You are very welcome. Glad it works for you and thanks for the feedback

---------------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1