trying to create a formula and require help.

I am trying to create a formula using if a cell is = to the letter A then
multiply one cell by another or, if that same cell is = to the letter B, then
multiply one cell by another. I would greatly appreciate some help on how
this would be typed.
Thanks in advance

=if(A1="A",b1*c1,if(A1="B",b2*c2,"invalid entry")).
In general, for two tests in nested ifs:
=if(first_condition,first_result,if(second_condition,second_result,other_result))
Enter the formula in the cell where the result should appear.

"Amste" wrote:

> I am trying to create a formula using if a cell is = to the letter A then
> multiply one cell by another or, if that same cell is = to the letter B, then
> multiply one cell by another. I would greatly appreciate some help on how
> this would be typed.
> Thanks in advance
>

You can use a nested if statement to do this. Here is one that I have in one of my worksheets: =IF(C290="H",PRODUCT(B290*goals!$C$1),IF(C290="S",PRODUCT(B290*goals!$C$2)," ")). The tricky part is making sure you have enough parenthesis at the end to close everything.

=IF(A1="A",B1*C1,IF(A1="B",D1*E1,"Something Else"))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Amste" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create a formula using if a cell is = to the letter A then
> multiply one cell by another or, if that same cell is = to the letter B,
> then
> multiply one cell by another. I would greatly appreciate some help on how
> this would be typed.
> Thanks in advance
>