Forum Discussion
ray75
Dec 06, 2025Copper Contributor
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...
Detlef_Lewin
Dec 07, 2025Silver Contributor
=IF(A2="","",B1+25-A2)
- ray75Dec 07, 2025Copper Contributor
Fantastic...... many thanks for your help and solution....