Formula assistance (IF Statment)

I have 3 columns: Column A has numeric values Column B has numeric values and empty cells. Column C is there to calc Columns A and B. I'm able to return a value between Columns A and B, if numeric values are present. I'd like to turn 0 or nothing in Column C, if Column B is empty.

Excel

Subodh_Tiwari_sktneer
Mar 25, 2020
toyawallace
You still have no data in columns you described in the latest file you uploaded.
Anyways, try one of the following formula depending which column actually contain the data.
=IF(ISNUMBER(B16),IF(B16>=0,B16-A16,0),0)
OR
=IF(ISNUMBER(N16),IF(N16>=0,O16-N16,0),0)
OR
=IF(ISNUMBER(B8),B8-A8,0)
OR
=IF(ISNUMBER(N16),O16-N16,0)
See which formula returns the desired output.

Abiola1
MVP
Mar 25, 2020
Hello,

Can you show us your formula or a file?
- toyawallace
  Copper Contributor
  Mar 25, 2020
  thanks, here's the formula: =IF(O16>=0,O16-N16)+IF(O16="",0)
- toyawallace
  Copper Contributor
  Mar 25, 2020
  =IF(O16>=0,O16-N16)+IF(O16="",0) Thanks
  - Abiola1
    MVP
    Mar 25, 2020
    =IF(O16>=0,O16-N1,0)
- toyawallace
  Copper Contributor
  Mar 25, 2020
  Abiola1
  Spend Governance.xlsx21 KB
Subodh_Tiwari_sktneer
Silver Contributor
Mar 25, 2020
toyawallace
You may adopt this approach...

=IF(B2="","",<your calculation here if column B is not empty>)

Place the above formula in C2 and replace <your calculation here if column B is not empty> part with actual calculation you are doing if column B is not empty.
- toyawallace
  Copper Contributor
  Mar 25, 2020
  Thanks, here's the calculation: =IF(O16>=0,O16-N16)+IF(O16="",0)
- toyawallace
  Copper Contributor
  Mar 25, 2020
  Subodh_Tiwari_sktneer
  Trying to reflect the following in column U:
  If N is >= to 0, then N-O.
  If N has no value, then column U should be 0.
  Spend Governance.xlsx21 KB
  - Subodh_Tiwari_sktneer
    Silver Contributor
    Mar 25, 2020
    toyawallace
    Did you upload a wrong file as there is no data in the columns you described?
    
    In the file you uploaded, the cells in column B which look empty but actually they contain a space in them. Why?
    If you select all the cells in column B which look empty and press Delete from the keyboard, you simply need the following formula...
    
    In H8
    
    =IF(B8>=0,B8-A8,0)
    
    and copy it down.
    
    Spend Governance.xlsx20 KB
toyawallace
Copper Contributor
Mar 25, 2020
toyawallace
Spend Governance.xlsx21 KB
mtarler
Silver Contributor
Mar 25, 2020
toyawallace would this work?
iferror( columnB - column A, 0)
- toyawallace
  Copper Contributor
  Mar 25, 2020
  mtarler
  Hi, here's the formula to reflect to return a value if N>=0, and return 0, if there is no value in N.
  =IF(O16>=0,O16-N16,IFERROR(O16-N16,0))
  Spend Governance.xlsx21 KB
  - mtarler
    Silver Contributor
    Mar 25, 2020
    toyawallace not sure why it isn't working if I understand what you want:
    =iferror(O16-N16,0)
    if you only want calculated if N>=0 then
    =iferror(if(N>=0,O16-N16,0),0)

Forum Discussion

Formula assistance (IF Statment)

Share