Forum Discussion

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
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

Copper Contributor

Mar 25, 2020

Subodh_Tiwari_sktneer

Hi there, you nailed it! 🙂

This formula worked. =IF(ISNUMBER(O16),IF(O16>=0,O16-N16,0),0)

Thank you so very much!!

Stay healthy and Be Safe!

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.

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.
JB_Coleman
Copper Contributor
May 12, 2023
Column G can have 9 different values
JB_Coleman
Copper Contributor
May 12, 2023
JB_Coleman

need answer to the multiply values in column G is this the right direction without using a lookup table?

=IF [(( G3 ='Qtr#3',(H3/100*E30/4),
         (G3 = 'Qtr#1',(H3/100*E3)/1),
         (G3 = 'Mo',(H3/100*E3)/12),
         (G3 = 'Sim',(H3/100*E3)/2),
       =IFerror (I3 = 0)
JB_Coleman
Copper Contributor
May 12, 2023
i see your samples. without using an inside "lookup table" with this work

=IF[(G3 ='Qtr#3',(H3/100*E3/4),
(G3 ='Qtr#2',(H3/100*E3/4),
(G3 ='Mo',(H3/100*E3/12),
(G3 = 'SIM',(H3/100*E3/2),
(G3 = 'ANN',(H3/100*E3),
=IF ERROR ( I3=0))]
JB_Coleman
Copper Contributor
May 12, 2023
no sample given
JB_Coleman
Copper Contributor
May 12, 2023
show me an example of the IF statement.
Alden