Automatically change input value

Copper Contributor

Hello,

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

 

 

Jan995_0-1650889915425.png

Jan995_1-1650889958423.png

 

 

 

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