Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

nikkiphish

macrumors newbie
Original poster
Jul 28, 2010
1
0
Hi there, I am currently in the process of starting my own business. I am using Numbers to create an inventory and I am stuck on a formula. In each row I have a product that I carry, followed by the options available for that item. Example: Business cards, and the next column is quantity with a pop up menu of all the available quantities. The next column needs to reflect the cost of the quantity selected. So if the quantity is 100, the next column needs to show $23, if the quantity is 150, then it would be $31, and so on. I thought I was on to something when I did this: =IF(F3=100, “$23”, “”) and got $23 to show up in the column, but I have no idea how to have several conditions, I keep getting errors. Help here would be GREATLY appreciated!!! Thanks!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.