Thread
:
removing the "-" sign in a calucation
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
external usenet poster
Posts: 4,624
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)
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey