Formula based on the first letter in a cell

[povikas]

Hello!

I'm a novice when it comes to using Excel, and I didn't find a solution to my problem, so I decided to register and ask for help.

I'm in need of a formula based on the first letter in a cell.

Example - if cell G2 first letter is "A", then cell I2 =C2/D2*F2,
but when cell G2 first letter is "B", then cell I2 =-(C2/D2*E2)

1.1 A little graph for illustration.

So that when i enter letter "A" in cells G2;G3;G4.. it gives me the formula =C2/D2*F2 in cells I2;I3;I4.. or when i enter the letter "B" in cells G2;G3;G4.., it gives me the formula =-(C2/D2*E2) in cells I2;I3;I4..

I hope you did understand my explanation and what it was that i needed

Thanks in advance!

 

[etaf]

Example - if cell G2 first letter is "A", then cell I2 =C2/D2*F2,
but when cell G2 first letter is "B", then cell I2 =-(C2/D2*E2)

any other letter likely to be entered
two ways to that

Asumming only A or B can be put in the cell and no more than 1 character

then in I2 put

=IF(G2="A", C2/D2*F2, -(C2/D2*E2))

OR

if you could have other letters or blanks
then in I2

=IF(G2="A", C2/D2*F2, IF(G2="B", -(C2/D2*E2), ""))


Now
if any other character in G2 it will just blank the cell

copy the formula down the column

if you have more than 1 character in G and just want to use the 1st character
then
=IF(left(G2,1)="A", C2/D2*F2, IF(left(G2,1)="B", -(C2/D2*E2), ""))

 

[Teeroy]

You could also try:
=LOOKUP(G2,{"A",1;"B",-1})*C2/D2*F2

or to make other values in G2 return 0:
=LOOKUP(G2,{"A",1;"B",-1;"C",0;-1E+99,0})*C2/D2*F2

 

[povikas]

I dub you the Knight of Surrey, godspeed.

Thanks!

 

[etaf]

your welcome