Microsoft Office excel 2007

Hi, looking for help with this formula. If cell A says "Apples" multiply cell B by .20. If cell A says "Bananas" then multiply cell B by .30.

Thanks for your help!

And would it be the same thing if I wanted to add more dimensions? e.g. Additionally, if cell A says "Strawberries" then multiply by .4

Look up the IF function in the Excel help files. It's pretty straight forward.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Ask Your Question

Weekly Poll