Mar 25 2020 07:25 AM
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 values are present. I'd like to turn 0 or nothing in Column C, if Column B is empty.
Mar 25 2020 07:38 AM
Mar 25 2020 07:42 AM
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.
Mar 25 2020 07:45 AM
Mar 25 2020 07:45 AM
Mar 25 2020 09:32 AM
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.
Mar 25 2020 09:53 AM
@toyawallace would this work?
iferror( columnB - column A, 0)
Mar 25 2020 10:05 AM
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))
Mar 25 2020 11:37 AM - edited Mar 25 2020 11:39 AM
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.
Mar 25 2020 11:44 AM
I apologize, I was providing an example in my first post. In the actual file. I need the value to populate in Column U. The columns to include the formula are O and N. If the value in N is blank or no value at all, I'd like for U to be 0. If the value in N>=0, then the value in U should be O-N.
Mar 25 2020 12:14 PM
@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)
Mar 25 2020 02:28 PM
SolutionYou 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.
Mar 25 2020 03:20 PM
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!
Mar 25 2020 10:22 PM
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.
May 12 2023 07:01 AM
Mar 25 2020 02:28 PM
SolutionYou 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.