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.

Abiola1's avatar
Abiola1
MVP
Mar 25, 2020
Hello,

Can you show us your formula or a file?
  • 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

         

  • toyawallace's avatar
    toyawallace
    Copper Contributor
    Mar 25, 2020
    thanks, here's the formula: =IF(O16>=0,O16-N16)+IF(O16="",0)

Resources