Forum Discussion
Lookup a value by comparing two units
Find the Z Factor From the Cell by comparing the pressure and temperature
You 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.
2 Replies
You 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.
- Thanks for the this valuable information..
