View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Converting Negative Numbers to Positive

How about

=IF(A1*A1=1,A1*A1,SQRT(A1*A1))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike" wrote:

another thought occurs

=SQRT(A1*A1)

"bmmclen" wrote:

There has to be a way to do this other than multiplying by -1???