Forum Discussion

4lvis_bondarenko

Copper Contributor

Mar 03, 2021

Solved

Formula help needed..

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.

Formulas and Functions

SergeiBaklan
Mar 04, 2021
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.

6 Replies

Riny_van_Eekelen
Platinum Contributor
Mar 03, 2021
4lvis_bondarenko Try this:
=IF(A1="Text 1",(B1-C1)*10,IF(A1="Text 2",(C1-B1)*10,""))
- 4lvis_bondarenko
  Copper Contributor
  Mar 03, 2021
  Nope, doesnt work mate 😞
  - Riny_van_Eekelen
    Platinum Contributor
    Mar 03, 2021
    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.
    alvis.xlsx9 KB

Resources