# MS Excel: Formula based on whether a cell has a value in Excel 2003/XP/2000/97

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)

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.

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