tech on the net

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:

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.