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.
That INDEX MATCH formula was from the older days.
Now, Numbers offers the SWITCH function, which is easier to use. The equivalent formula using SWITCH is:
=SWITCH(C3,1,1500,2,2000,3,3335,"out of range")
generalized as:
=SWITCH(expression,switch-value,if-match, default)
You just keep adding switch-value, if-match pairs as needed and at the end (if you want; this is optional) a default value for cases where there is no match with the value in cell C3.
SG
“Find value”? In Numbers
