Thread: How do I make them all negative??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roelof van Wyk
 
Posts: n/a
Default How do I make them all negative??
use a simple if statement i.e.
=IF(A2<0,A2,A2*-1)
Reply With QuoteReply With Quote