Automatically change input value

Occasional Visitor


I'm from Slovakia so I apologize for English first,

I am working on a bachelor's thesis in civil engineering and I have the following problem:


In cell G133 I need to find a value less than 90% utilization so that cell C126 will automatically change if it does not reach that value or closest to 90% utilization (cell C126 should select values from Range C68: C91)


!! in cell G133 I already have the formula = ABS ($H$52 / G97) * 100 - the only solution I find reasonable is to use VBA - but I don't know how to set this logical condition








1 Reply
You can use Data, What-if Analysis, Goal seek to do this.