If Only...

If only this is x, then it’s y. Things always have conditions – you can have this on the condition that / if you do that.

Example

I have a list of names (with their titles – Mr, Mrs & Miss) and I want to know the gender.

Excel Formula: =IF(logical_test,[value_if_true],[value_if_false])

Formula Made Easy

Tip

What if I wanted to add cells if they have a certain criteria? I'd use SUMIF.

What if I wanted to count cells if they have a certain criteria? I'd use COUNTIF.

Note:

Rows to Columns, Columns to Rows