How do you turn a negative number into a positive one?

A

Alina Shah2021-09-13 10:52:27

Google Sheets

Alina Shah, 2021-09-13 10:52:27

https://docs.google.com/spreadsheets/d/1rK6gNwXtk0...

In cell N2, a negative number is obtained, how to make it positive?
Now N3 has an additional formula, but how to combine them?

formula in N2:
=I1-LEFT(VALUE(TEXT(A1;"DD"));1)*2

formula in N3:
=IF(N2<0;UMINUS(N2);N2) You

need to combine them somehow: )
any thoughts?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

I

idShura, 2021-09-13
@Shah_Alina

Use ABS , here is an example formula in cell N1
=ABS(I1-LEFT(VALUE(TEXT(A1;"DD"));1)*2)

V

Vladislav Orlov, 2021-09-13
@haveacess

*-1 negative number = get positive