Is there a way I can do an 'if' sum with a pop-up menu?
In Numbers, I am trying to have a sum that looks like this:
| Pop-up menu with options a, b, c | x | y |
| If pop-up menu = a, then multiply x with y |
Thanks
MacBook Air, Mac OS X (10.7.4)
Question marked as
Best reply
Hi jamang,
Is this what you want?
Formula in E2 (and Fill Down)
=IF(B2="a",C2*D2,"")
If you choose a from a Pop-Up, E multiplies X and Y.
If the Pop-Up in not equal to a, E will show "" (NULL, the cell will appear blank).
Regards,
Ian.