Returning Text or Numbers From IF

You have built solid tests. Now let's focus on the two outcomes IF returns.

An IF result can be a piece of text, a number, a blank cell, or even another calculation. Choosing the right kind of output makes your sheet clear and useful.

To show words, wrap each outcome in double quotes. The quotes tell the spreadsheet "treat this as literal text".

For a payment status in A2:

Without the quotes the spreadsheet would think "Paid" is a name or formula and likely show an error.

Numbers are returned without quotes. Quoting a number would turn it into text that you cannot add up later.

Award 100 points for a win, 0 otherwise:

Because these are real numbers, you can SUM the result column for a grand total.

Sometimes the cleanest false result is nothing at all. Use a pair of empty quotes "" to leave the cell looking blank.

To show a warning only when stock runs low:

When stock is fine, the cell stays empty instead of cluttering your sheet with the word "OK".

An outcome can be a formula, not just a fixed value. The spreadsheet runs that calculation only when its branch is chosen.

Give a 10% discount to large orders, full price otherwise. Price is in A2:

Here the TRUE branch multiplies the price by 0.9, while the FALSE branch leaves it unchanged.

You can build a message that includes a cell's value using the & joiner.

If a name sits in A2, greet only VIP customers:

The & glues the word "Welcome " to the name. Notice the space inside the quotes so the words do not run together.

Salespeople earn 5% commission on sales above 1000, and nothing below that. Sales are in column A.

For row 2:

The TRUE branch computes the commission as a real number, so you can total the column and pay out the result.

Choosing text or number outcomes affects what you can do next.

• Text results like "Pass" are great for reading but cannot be summed
• Number results like 100 can be added, averaged, and charted

If you plan to do math on the column afterwards, return numbers. If it is just a label for people to read, text is fine.

It is common to have one IF column for a readable label and another for a number you can total.

Column C might show =IF(A2 >= 60, "Pass", "Fail") for humans, while column D shows =IF(A2 >= 60, 1, 0) so you can SUM how many people passed.

Same test, two different outcome types, each serving a purpose.

A tidy habit is to make both outcomes the same kind of thing.

If the TRUE branch returns text, let the FALSE branch return text too. Mixing a number on one side and text on the other can confuse later calculations and sorting.

Consistency keeps your columns predictable and easy to work with.

Returning text, numbers, blanks, calculations, and joined strings all works identically in Microsoft Excel and Google Sheets.

The double-quote rule for text and the bare-number rule are universal across both tools.

Decide which outcome type fits the goal.

You learned how to shape IF's output:

• Text outcomes need double quotes; numbers do not
• Use "" to leave a cell blank
• An outcome can be a live calculation like A2 * 0.9
• Use & to build messages that include cell values
• Return numbers if you will do math later; text for plain labels

Next you will spot and fix the most common IF mistakes.