SOLVED

# IF + AND function won't give the correct answer

Copper Contributor

# IF + AND function won't give the correct answer

after two separate statements (is the value more than 8? = TRUE)

I wanted to have a separate column, where I want to see when both statements are TRUE). If they are both TRUE, the answer should be 'Rendabel'. If both are not 'TRUE', the answer should be 'no'

Despite both fields are 'TRUE', the answer is still 'No'... The function is correct, I guess. What can be the reason please? Thx

4 Replies

# Re: IF + AND function won't give the correct answer

``=IF(AND(J137=TRUE,K264=TRUE),"Rendabel","no")``

You can try this formula.

# Re: IF + AND function won't give the correct answer

The function you wrote is the same, but in german.

Unfortunately it still does not give the correct answer.

If someone can help me out, that would be great.

Thank you

best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: IF + AND function won't give the correct answer

@Jboudewi Remove the quotes around TRUE, or even better try this:

=IF(AND(L137;M264);"Rendabel";"no")

# Re: IF + AND function won't give the correct answer

Thx, that worked out welll :)
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: IF + AND function won't give the correct answer

@Jboudewi Remove the quotes around TRUE, or even better try this:

=IF(AND(L137;M264);"Rendabel";"no")