Absolute Value

G

Guest

How do you create a function to yield an absolute value of a cell in another
cell. For example, A1= -23. I want the absolute value 23 to be deplayed in
B12. But, if the A1 value is 23 instead, still the absolute value in B12
would still be 23.

hope this makes sense.

Thx
eric
 
G

Guest

hi Eg.

=abs(a1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"EG" escreveu:
 

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

How do I set up a formula to give me an average based on IF? 1
If cell value is between XX and XL, display B 4
IF Formula Porblems 1
absolute value 3
Using icon sets with relative references 0
if true, if not nested if funcion 2
Excel How to code in excel vba 2007 using absolute refernce for cells 1
absolute reference fill 1

Top