multiply column values based on multiple criteria

[Yokosuka]

Hello,

I am wondering how can I to multiply values in column B based on some criteria in Column A. For example: I would like to multiply values in Column B (x1.5) in case of cell values in A are y, gb, r and u. if the value in A is a number keep the same value in B and finally if it is zz and c in column A, multiply B by 2.
Thank you for your guidance. Please see the attached file.

[PCI]

Just to be clear, when is asked
"to multiply values in Column B (x1.5) in case of cell values in A are y, gb, r and u. if the value in A is a number keep the same value in B and finally if it is zz and c in column A, multiply B by 2."
it means the result is in column C ...!

What about when there is in column A
x
t
r28
c

[LeoTaxi]

result in same column or new ?

Kind regards
Leo

[PCI]

If previous comments are solved try
C2 =IF(ISNUMBER(A2),1,VLOOKUP(A2,$H$2:$I$6,2))*B2

fill H2;I6 with
zz 2
y 1.5
u 1.5
r 1.5
gb 1.5

[Yokosuka]

Salut PCI,

I would like to get the results in the same column if it is possible of course, otherwise column C is ok.


Merci d'avance.

Thank you so much.

Yukiko

[PCI]

If you want the result in column "B", it means you want to modify column "B" , then a macro is needed.

What about when there is in column A
x
t
r28
c

[Yokosuka]

Salut PCI,

Thank you for your reply. I would like to do this using a Macro. In case the following values are found in column A: x,t,r28 and c, then divide by 2.

Merci pour ton soutien.

Yukiko.

[LeoTaxi]

Maybe with this

Please Login or Register  to view this content.

Kind regards
Leo

[PCI]

See next code

Please Login or Register  to view this content.

[Yokosuka]

it works perfectly thank you so much. Thread marked as solved (y)