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_conditi on,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

=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" wrote in message
...
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.


--
kimmer4861
------------------------------------------------------------------------
kimmer4861's Profile: http://www.excelforum.com/member.php...o&userid=30755
View this thread: http://www.excelforum.com/showthread...hreadid=504615