Home » Forums » Open Source Learning Center » Question and Answer

Need help with a formula =if(A1<=90,A1+90,A1-90)

Submitted by harrylalli on 23 May, 2013 - 10:30

=if(A1<=90,A1+90,A1-90)

using this formula - 90 +90 =0 and 90-90 = 0 , I want to have the answers = 180 ,
so 90+90 = 180 , and 90-90 = 180 , As I cant use 0 as a figure

Any ideas?

‹ Problem with extracting large amount of data from Oracle through ADODB Excel Calculate the wrong results ›
»

u can use abs function

Submitted by milind on 25 May, 2013 - 04:28.

=IF(A1<=90,ABS(A1)+90,ABS(A1)-90)

»