Formula help needed..

[4lvis_bondarenko]

Hello! Im a little bit stuck here with this nested formula that doesn work for me.  Here is what i am trying to do here: 

IF A=text1 then (B-C)*10 and IF A=text2 then (C-B)*10

Can anyone helpm me please?

Thanks in advance.

[#2]

@4lvis_bondarenko Try this:

=IF(A1="Text 1",(B1-C1)*10,IF(A1="Text 2",(C1-B1)*10,""))

[#3]

Nope, doesnt work mate :(

[#4]

@4lvis_bondarenko Perhaps your local settings require a semi colon to separate the arguments in a formula. The attached workbook contains a working example, that will automatically adjust to your local requirements. Try.

[#5]

@Riny_van_Eekelen This is the error that i get and error trace tool show where the fault is but i dont understand whats wrong with it.

[#6 · Accepted solution]

@4lvis_bondarenko 

Instead of I:I please use I2:I10000, even better dynamic ranges, even more better transform range to table.

Same for each column in formula.

[#7]

Sorted. Thanks a lot mate.