Sep 01 2020 12:44 PM
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.
Sep 01 2020 12:49 PM
That could be like
=IF( (A1="") + (B1=""), "", B1-A1)
if no any other conditions to check.
Sep 16 2020 02:49 AM
Since you have not disclosed that what formula you have used for TOTAL GROWTH, therefore I would like to suggest two possible formula.
=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.
=IF(ISBLANK(J6),"",SUM(H6:J6))
N.B :
If only J6 (Spring MAP) is blank then, formula keeps the cell K6 BLANK.
Note: