Subtract a number according to Drop Down list options

[PhilipeC]

I would like to subtract a number according to Drop Down list options. My Drop Down list is in colums B4 to B20 and each column has the same tree options: A-B-C , and there are columns D4 to D20 and F4 to F20 each column with numbers in reference to those options. Columns G4 TO G20 are the subtraction results. IF option A is chosen i want to subtract F(column number) - D(Column number) = G(Column number) , If option B is chosen i want to subtract to subtract D(Column number) - F(Column number) = G(Column number), option C would be the same as B, subtract D(Column number) - F(Column number) = G(Column number). Just an example: in column B4 i choose option B from the Drop down list, than: D4 - F4 = G4.
Thank you

 

[Legacy 143009]

I would like to subtract a number according to Drop Down list options. My Drop Down list is in colums B4 to B20 and each column has the same tree options: A-B-C , and there are columns D4 to D20 and F4 to F20 each column with numbers in reference to those options. Columns G4 TO G20 are the subtraction results. IF option A is chosen i want to subtract F(column number) - D(Column number) = G(Column number) , If option B is chosen i want to subtract to subtract D(Column number) - F(Column number) = G(Column number), option C would be the same as B, subtract D(Column number) - F(Column number) = G(Column number). Just an example: in column B4 i choose option B from the Drop down list, than: D4 - F4 = G4.
Thank you

G4 =IF(A4="A",F4-D4,IF(OR(A4="B",A4="C"),D4-F4))

Copy through G20

 

[razaas]

Even this should work

=IF(B4="A",F4-D4,D4-F4)

 

[Legacy 143009]

Even this should work

=IF(B4="A",F4-D4,D4-F4)

Nope. It can be a problem if dropdown is empty.

 

[Legacy 143009]

Even this should work

=IF(B4="A",F4-D4,D4-F4)

But the right column to check is B, not A. You are right


=IF(B4="A",F4-D4,IF(OR(B4="B",B4="C"),D4-F4),"")