ScorpionKing
New Member
- Joined
- Aug 18, 2005
- Messages
- 44
How can I create an if then function (non VBA) to manipulate (increase or decrease in increments of 10) one number (A) until another number is less than 100 (C). Please keep in mind that (A) is part of the formula of (C) so I can possibly run into circular reference issues. I also have more than 7 possible increments of (A) so the If then function will have to be defined as a name.