Simultaneous 'if' statements

Hi All,

Thank you so much for your answers! They are a great help!

@ Asar_k and jonmo1: your formulas worked except that it did not leave a blank column if C1 = TRUE

@daffodil11, ben_hensel, martindwilson - all worked thank you!

I have used: IF(C1=TRUE, "", IF( LEFT(A1, 1) = LEFT(B1, 1), TRUE, FALSE)) as I am new to this so it helps me understand what I am asking Excel to do.

Just to check, am I telling Excel: if C1 reads true, put a blank space and for all others (not sure why I dont need 'IF C1 = FALSE?), if the first character from the left in A1 and the first character from the left in B1 are the same, designate 'TRUE' and if not 'FALSE'?

Thank you :-)

Originally Posted by Ant123

... (not sure why I dont need 'IF C1 = FALSE?) ...

The IF function tests for an EITHER / OR situation. You can think of it as:

=IF(Condition_to_be_tested, Action_if_TRUE, Action_if_FALSE)

so if the condition is TRUE then the first action will be carried out, if it is FALSE then the second action will be evaluated. Thus if you test for IF(C1=TRUE,... (or more simply IF(C1,... ) then you don't also need to test for IF(C1=FALSE,... as that is implied in the second action.

Hope this helps.

I'm sure the contributors are grateful for your feedback, but if the answers take care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Hi Pete,

Thanks very much for the information. It is a great help! :-)