Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional column comparison, if true then print

Status
Not open for further replies.

Nerdhurd

Technical User
Jan 11, 2005
57
US
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?
 
got it figured out

=IF(B1=D1, TRUE, FALSE)
 
Howdy, Nerdhurd.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top