CSV formula

studio

#1

Hello,

I need to add a row to DT and then paste it in .csv file and I need the following two formulas to work.

=IF(M2=“hr7924840081500152136”; “Please check IBAN”; “Ok”)
=IFERROR(IF(ABS(B2-C2)<0.1;OK;“Total ukupno is different from ukupno. Please check it.”);"")

How should I use double quotes to make it happen?


#2

Try replacing ; with ,


#3

That wasnt the problem but I have already figured it out. The problem is now, that in formula the references to the cell are fixed. Is there a way how to replace B2-C2 by B(number of current row in DT) - C(number of current row in DT)?