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.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
I want to include a value in An IF formula, but it won’t work because the cell displays an deployable menu format.
How can I use a value from the deployable menu in formulas?
MacBook Pro 15″, macOS 11.2
You are doing it correctly. The formula looks correct. Look at the pop up menu and see if you have a trailing space after "boneless". Or, as a different test, in a cell put the formula =LEN(A2) and see if the length is 8 like it should be.
You are doing it correctly. The formula looks correct. Look at the pop up menu and see if you have a trailing space after "boneless". Or, as a different test, in a cell put the formula =LEN(A2) and see if the length is 8 like it should be.
Thank you so much. Indeed, the lenght was of 9. I already corrected it and now is doing fine.
Quote a value from a cell with deployable menu format in a formula
