Modulus

N

Nav

How can I get a negative figure eg. -15 to show the
modulus equivalent ie.15 without actually using a formula
such as x-1.

Does a function exist for this?
 
R

Rafael Ortiz

Excel dooes have an absolute value function. Sample for value in A1:
=ABS(A1).

MRO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and filtering text 0
Copy addition formula of non-consecutive horizontal cells 2
You'll need a new app to open this about link 1
Countifs or a pivot 1
extract decimal and convert to integer 9
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
#NAME? 10
modulus 11 formula 1

Top