I have a 2-column table listing 'Size' and 'Point'. On a seperate sheet, I have three cells listed across as 'Estimate', 'Rating', and 'Breaking'. In this, the values in 'Breaking' are equal to 'Rating' * 1.25 and I want to increase 'Rating based on increasing values of 'Point' until the value of 'Breaking' is greater than 'Estimate'. In addition, 'Rating' has an initial value set equal to another cell. Is there a way to do this without using a macro?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel: Compareing 2 cells based on a record
- Thread starter fiel
- Start date
Would Tools -> Goal Seek help?
It's not too clear what your dataset is. How deep is the Size/Point table? How do those values relate to each other?
If Goal Seek doesn't help it may be worth posting an example of your tables. You can use the [ignore][tt] [/tt][/ignore] tags to switch into mono-spaced font so you can get the columns lined up (I acknowledge anotherhiggins for that tip for posting Excel data).
It's not too clear what your dataset is. How deep is the Size/Point table? How do those values relate to each other?
If Goal Seek doesn't help it may be worth posting an example of your tables. You can use the [ignore][tt] [/tt][/ignore] tags to switch into mono-spaced font so you can get the columns lined up (I acknowledge anotherhiggins for that tip for posting Excel data).
- Status
Similar threads
- Locked
- Question