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?
The formula that you would use is:
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.
(scroll to see more)