Oct 23 2021 08:05 AM
Find the Z Factor From the Cell by comparing the pressure and temperature
Oct 23 2021 08:30 AM
SolutionYou shouldn't type the { } around the formula. Excel will add them automatically if you confirm the formula with Ctrl+Shift+Enter to turn it into an array formula. (In Excel in Microsoft 365/Office 2021 this isn't necessary anymore). You'll have to unmerge the cell with the formula first.
See the attached version.
Oct 28 2021 10:05 PM
Oct 23 2021 08:30 AM
SolutionYou shouldn't type the { } around the formula. Excel will add them automatically if you confirm the formula with Ctrl+Shift+Enter to turn it into an array formula. (In Excel in Microsoft 365/Office 2021 this isn't necessary anymore). You'll have to unmerge the cell with the formula first.
See the attached version.