search

pyscripter / XLRisk

Excell addin for performing Monte Carlo simulation
MIT License
112 stars 24 forks source link

Use of Indirect formula for TornadoX and TornadoY named range #7

Closed mrjkwon closed 1 year ago

mrjkwon commented 1 year ago

The use of the INDIRECT() formula in defining TornadoX and TornadoY means that the first reference to the worksheet name does not change when the user decides to change the name of the worksheet

pyscripter commented 1 year ago

Thanks.

Could you please show here the wrong formula and the corrected one.