tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

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.