LinkBack URL
About LinkBacks
I am working on a product pricelist. Product is sold by the piece or by the square foot, with each having a different markup. How do I get Excel 2000 to recognize the difference between "pc." & "s/f" & price accordingly?
I am working on a product pricelist. Product is sold by the piece or by the square foot, with each having a different markup. How do I get Excel 2000 to recognize the difference between "pc." & "s/f" & price accordingly?
= if(B1 = "pc.", someExpression, if(a1 = "s/f", someOtherExpression, "oops") )
For example,
= if(B1 = "pc.", 10*A1, if(a1 = "s/f", 20*A1, "oops") )
Last edited by shg; 02-28-2009 at 04:12 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks