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.
You may adopt this approach...
=IF(B2="","",<your calculation here if column B is not empty>)
Place the above formula in C2 and replace <your calculation here if column B is not empty> part with actual calculation you are doing if column B is not empty.
Thanks, here's the calculation: =IF(O16>=0,O16-N16)+IF(O16="",0)