Greetings all, lets say you have an excel sheet with 2 columns. If column A is not equal to column B then print fales else print true. Is there a forumla to do this?
It's actually easier than that. Just use
[COLOR=blue white]=B1=D1[/color]
If it's true, then the cell will display TRUE, otherwise it will display FALSE. No need to use an IF statement.
[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red] -Mitch Hedberg
Help us help you. Please read FAQ181-2886 before posting.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.