Ok so I can't figure this out. I am creating a worksheet to figure out commission on the sales of cell phones and phone accessories. I have created a list of phones and accessories but I put them on 2 different worksheets. I am using an if function to determine whether or not the sale is a phone or an accessory and how many there are this is the formula I created
=if(d2="Phone",if(f2="",vlookup(e2,'Handset Pricing Matrix'!$A$2:$B$50,2,"FALSE"),(vlookup(e2,'Handset Pricing Matrix'!$A$2:$B$50,2,"FALSE")*f2),if(d2="Accessory",if(f2="",vlookup(e2,Accessories!$A$1:$B$202,2,"FALSE"),(vlookup(e2,Accessories!$A$1:$B$202,2,"FALSE")*f2),"")
d2 = type of sale (phone or accessory)
e2 = name of product
f2 = number sold
i am getting a too many arguments error any suggestions?
Bookmarks