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 have created a somewhat complex workbook to keep track of eBay sales and would like to create a pop up menu for the rows in one of the columns (say, column D) to be able to choose from 2 different options - first being a simple selection for “$0.00”. For the second choice in the pop up, I am wondering if I can create a function/equation in the selection that will return a value = to 1% of “A+B-C”? Hopefully this makes sense...Thanks!
Note the function cannot be within a Pop-Up itself.
It's hard to guess exactly what you are trying to accomplish but if you only have two choices, rather than several more, then perhaps a Checkbox would do what you want.
=IF(E2,1%*(A2+B2−C2),0)
BTW, there's no such thing as a "complex workbook" in Numbers. That's Excel-speak. Numbers has documents (sometimes called spreadsheets, which have sheets, which have tables and other objects.
SG
Note the function cannot be within a Pop-Up itself.
It's hard to guess exactly what you are trying to accomplish but if you only have two choices, rather than several more, then perhaps a Checkbox would do what you want.
=IF(E2,1%*(A2+B2−C2),0)
BTW, there's no such thing as a "complex workbook" in Numbers. That's Excel-speak. Numbers has documents (sometimes called spreadsheets, which have sheets, which have tables and other objects.
SG
OK, I think I understand the solution that you were giving in reference to creating a column with a checkbox and I do in fact think that may be the way to go, however I attempted to create the formula you gave and this is what was returned:
"…however I attempted to create the formula you gave and this is what was returned:"
Ignoring the content of the four tokens, but attending to the structure of the formulas, what differences do you see between your formula and the one provided by SGIII?
Yours:
SGIII's
Regards,
Barry
checkboxes definitely would not help, but it sounds like you’ve answered it - cant input a function into a pop-up...thanks! FYI by complex I just meant it had a lot of different equations in the sheet.
thanks again!
Numbers pop up menu help
