View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Wright
 
Posts: n/a
Default trying to create a formula and require help.

=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