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:
"What If..." image sourced from worldartsme.com
Comments