For instance, if you have a profit loss of -500, to get the absolute value, you would type: =ABS(-500) The function will return 500, disregarding the negative sign. ... Profit and Loss Analysis.