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:
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!
"…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
Numbers pop up menu help
