Island Gryl
New Member
- Joined
- Jan 11, 2011
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
I'm getting a message that my formula won't work because it is a circular reference and just wanted to check in with you experts to see if my approach can work or if I have to approach this differently. It seems like its a simple issue and I hate to have to add a column to deal with this.
I have a Quantity Column L16 that contains a 1 and a Item name column M16 that explains that the item sold is a "Buy 2 Get 1 Free"
The formula that I am using resides in L16 '=IF(ISNUMBER(SEARCH("2",M16)),(L16+2),L16)
It returns a 0 after explaining that the circular reference might make my results unreliable.
I was hoping for a 3.
I am most grateful for anyone who has time to comment on this.
Thank you
I have a Quantity Column L16 that contains a 1 and a Item name column M16 that explains that the item sold is a "Buy 2 Get 1 Free"
The formula that I am using resides in L16 '=IF(ISNUMBER(SEARCH("2",M16)),(L16+2),L16)
It returns a 0 after explaining that the circular reference might make my results unreliable.
I was hoping for a 3.
I am most grateful for anyone who has time to comment on this.
Thank you