Forum Discussion
ajmal_pottekattil_yoousuf
Oct 19, 2021Iron Contributor
How to Find the Z Factor From the List
Below I attached the excel list and please help to find the Z Factor From the List When We Enter the Temperature & Pressure In the particular Cell the Z factor is lookup from the list.
ajmal_pottekattil_yoousuf
Oct 19, 2021Iron Contributor
The Answer is showing "N/A"
OliverScheurich
Oct 19, 2021Gold Contributor
In my sheet it shows "1,0017". Did you enter formula as matrix with ctrl+shift+enter? This puts the curly brackets { } around the formula.
- ajmal_pottekattil_yoousufOct 21, 2021Iron Contributor