Excel Formulas

Copper Contributor

I made a spreadsheet and I added a formula so that one of the columns calculates the difference between numbers in two other columns. That worked, but it's a situation where the people I work with will add values to the spreadsheet over time and I don't want the column that will find the difference to calculate a negative number after the first column number is entered. I want the difference formula to show only when both the values are entered in the other columns. I think I need to add a condition, but I can't figure out what to put. Basically I want the column that will show the difference to wait to calculate until both of the other values are entered. 

2 Replies

@Mariel617 

That could be like

=IF( (A1="") + (B1=""), "", B1-A1)

if no any other conditions to check.

@Mariel617 

 

Since you have not disclosed that what formula you have used for TOTAL GROWTH, therefore I would like to suggest two possible formula.

 

Rajesh-S_0-1600249092654.png

 

  • Formula in cell K6:

=IF(OR(ISBLANK(H6),ISBLANK(I6),ISBLANK(J6)),"", SUM(H6:J6))

 

N.B : 

If either of cells in range H6:J6 is blank, then formula returns BLANK in cell K6.

 

  • Another formula in K6:

=IF(ISBLANK(J6),"",SUM(H6:J6))

 

N.B : 

If only J6 (Spring MAP) is blank then, formula keeps the cell K6  BLANK.

 

Note:

  1. You need to adjust cell references in the formula as needed.
  2. You may replace SUM function with any other of your need.