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...
Hi ray75,
You can make sure B2 stays blank until A2 has a value by using an IF statement. Replace your formula with:
=IF(A2="","",B1+25-A2)
Optional: If you only want B2 to calculate when A2 contains a number, use:
=IF(ISNUMBER(A2),B1+25-A2,"")
This way, B2 remains empty until A2 has a valid entry, exactly as you described.
Hope this helps!