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.

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Mar 25, 2020

toyawallace 

You're welcome! Glad it worked as desired.

 

Please take a minute to accept the post with the provided solution as a Best Response/Official Answer to mark your question as Solved.

 

Stay home and be safe.

JB_Coleman's avatar
JB_Coleman
Copper Contributor
May 12, 2023
show me an example of the IF statement.
Alden
  • mtarler's avatar
    mtarler
    Silver Contributor
    May 12, 2023
    the example IF statements are a couple or messages up (I changed the "Best Response" to that reply). If you have additional questions or particular situation that doesn't fit here, maybe start a new post with your question. You can always include a link to this thread if it is relevant.

Resources