Send to a Friend

Fallenangel's avatar

Combining IF statements in Excel?

Asked by Fallenangel (260points) October 9th, 2008

I need to Combine about 5 IF statements in Excel, but have no idea how to do it. I can do one If statements with 2 outcomes based on true or false, but I cant go further than that, Can someone help?

(Here’s what I need)
IF (A1 = “A”;A2*B1;(A1=“B”;A2*B2 and so on and so forth.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.