Forum Discussion
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 ...
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.
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)
Column G can have 9 different values