Forum Discussion
Solved
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 s...
Jboudewi Remove the quotes around TRUE, or even better try this:
=IF(AND(L137;M264);"Rendabel";"no")
Thx OliverScheurich
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
Jboudewi Remove the quotes around TRUE, or even better try this:
=IF(AND(L137;M264);"Rendabel";"no")
- Thx, that worked out welll 🙂