Formula in write cell

[salvatore.quimi]

Hi all,

I use write cell activity to write below formula “=SUM(ABS(C2:C3))” but when this activity is performed in my excel I have the error with this formula “=SUM(ABS(@C2:C3))”

Could you support?

Regards,
S.

[Gokul001 (Gokul Balaji)]

Hi @salvatore.quimi

What action need to perform in the cell ?

Regards
Gokul

[salvatore.quimi]

Hi @Gokul001, write the formula “=SUM(ABS(C2:C3))”

below an example

[Gokul001 (Gokul Balaji)]

Hi @salvatore.quimi

Have a look on the document

ABSOLUTE Function in Excel (ABS)

Regards
Gokul

[salvatore.quimi]

Hi @Gokul001

I had a look on the sharing document, it’s nice but If I try the same formula:

In my Excel return this formula “=SUM(ABS(@C2:C3))”

Any suggestion?

Thanks in advanced

[Gokul001 (Gokul Balaji)]

@salvatore.quimi

“=SUM(ABS(@C2:C3))”

What action need to be done in the excel using this formula can you explain a bit?

Regards
GOKUl

[salvatore.quimi]

Hi @Gokul001

I have this excel (in attached) and I sum the value of cell C2 and C3 in absolute value. So I use the formula “=sum(abs(C1:C2))”
test.xlsx (8.5 KB)

Regards,
S.

[Gokul001 (Gokul Balaji)]

Look into document @salvatore.quimi

How to sum the absolute values in Excel?.

Regards
Gokul

[Gokul001 (Gokul Balaji)]

HI @salvatore.quimi

Try this formula

=SUM(ABS(C2),C3)

Regards
Gokul

[salvatore.quimi]

Hi @Gokul001

thank you for your support.
Finally I found the formula “=sumproduct(abs(C2:C3))”

Regards,
S.