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.
Hi, here's the formula to reflect to return a value if N>=0, and return 0, if there is no value in N.
=IF(O16>=0,O16-N16,IFERROR(O16-N16,0))
toyawallace not sure why it isn't working if I understand what you want:
=iferror(O16-N16,0)
if you only want calculated if N>=0 then
=iferror(if(N>=0,O16-N16,0),0)