Forum Discussion
Controlling Formula Output in Excel Based on Cell Entry
Scenario Description In this scenario, cell B1 in Excel contains a value of 50. Cell B2 uses the formula =B1+25-A2 to calculate its value. When the number 25 is entered into cell A2, the result in B...
=IF( ISNUMBER(A2), B1 + 25 - A2, "" )B2 will display a numeric result, only if A2 contains a number