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.
Trying to reflect the following in column U:
If N is >= to 0, then N-O.
If N has no value, then column U should be 0.
Did you upload a wrong file as there is no data in the columns you described?
In the file you uploaded, the cells in column B which look empty but actually they contain a space in them. Why?
If you select all the cells in column B which look empty and press Delete from the keyboard, you simply need the following formula...
In H8
=IF(B8>=0,B8-A8,0)
and copy it down.