You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I saw this on another thread where I am copying a formula, but I cannot seem to enter the last part in the current version of Numbers…
When I type ‘FIND’ in the formula, this ‘find value’ doesn’t come up as an option. How to enter it?
In this case, 'find value' is not a function, it is a parameter passed to the MATCH() function.
MATCH() takes three parameters, what to look for, where to look for it, and how to search.
In the above example, MATCH is looking for the value of cell C3 in in series {1, 2, 3}.
The find value option tells it to find the exact match, or throw an error.
You select this value by clicking on it and choosing from the menu:
or just enter '0' and let Numbers figure it out.
“Find value”? In Numbers
