Forum Discussion

toyawallace's avatar
toyawallace
Copper Contributor
Mar 25, 2020
Solved

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 ...
excel
  • Subodh_Tiwari_sktneer's avatar
    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.

toyawallace's avatar
toyawallace
Copper Contributor
Mar 25, 2020
=IF(O16>=0,O16-N16)+IF(O16="",0) Thanks
Abiola1's avatar
Abiola1
MVP
Mar 25, 2020
=IF(O16>=0,O16-N1,0)

  • toyawallace's avatar
    toyawallace
    Copper Contributor
    Mar 25, 2020

    Thanks, it's still returning a #Value

     

Resources