trying to create a formula and require help.

A

Amste

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
 
B

bpeltzer

=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.
 
K

Ken Wright

=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 :)
------------------------------­------------------------------­----------------
 
K

kimmer4861

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.
 
Top