PA_Commons
New Member
- Joined
- Jun 7, 2014
- Messages
- 6
To make my question easy let's say I have two columns A and B. So my issue is that I would like to easily format my B column with text. In my A column I have inventory numbers. Additionally some of the data I pull over already has pre-filled text in column B. I don't want that text to be changed. I only want to change empty cells.
So I tried this:
=IF(AND(B2 = "", 1000 < A2 < 2000), "Place Order", "Don't Place Order")
But I got a circular argument error. Am I on the right track here?
So I tried this:
=IF(AND(B2 = "", 1000 < A2 < 2000), "Place Order", "Don't Place Order")
But I got a circular argument error. Am I on the right track here?