totn Excel

MS Excel 2003: Formula based on whether a cell has a value

This Excel tutorial explains how to create a formula based on whether a cell has a value in Excel 2003 and older versions (with screenshots and step-by-step instructions).

Question:I'm trying to create a formula in Microsoft Excel 2003/XP/2000/97 that would do the following:

If cell B1 has no value, then the result would be the value located in cell A1.
If cell B1 has a value, then the result would be cell B1+10.

How would I do this?

Answer: You should be able to create this formula using a combination of the IF function and the ISBLANK function.

The formula that you would use is:

=IF(ISBLANK(B1),A1,B1+10)

Microsoft Excel

Based on the example spreadsheet above, the formula would return 13. Since cell B1 has no value, the formula returns the value located in cell A1 which is 13.

Microsoft Excel

Based on the example spreadsheet above, the formula would return 88. Since cell B1 does have a value, the formula returns B1+10.