rodkuusinen
New Member
- Joined
- Dec 5, 2021
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
How do I combine the results of C and D columns and generate a true/false statement in column E Column C =IF(A2<A1,TRUE,FALSE) Column D =IF(B2<B1,TRUE,FALSE) I have tried this formula but it always generates a FALSE STATEMENT Column E =IF(AND(C2="TRUE",D2="FALSE"),TRUE, FALSE) Once this is correct I need to take it further. I need to create a true statement for any combination of results except for TRUE AND TRUE or FALSE AND FALSE So If Column C = TRUE but Column D = FALSE Column E = TRUE If Column C = FALSE but Column D = TRUE Column E = TRUE If Column C = TRUE but Column D = TRUE Column E = FALSE If Column C = FALSE but Column D = FALSE Column E = FALSE Im 68 and should know better but what the heck I don't. Your help is appreciated
|