Forum Discussion
Formula assistance (IF Statment)
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.
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.
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 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!
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.
- no sample given
