View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default removing the "-" sign in a calucation

Or, more succinctly:

=ABS(A1 * 0.75)

In article ,
smartin wrote:

If you want this to always return a positive number:
=ABS((A1*0.25)-A1)