Making a cell show negatives as positives

[yamaha333]

Please can somebody help.

I want this formula to show any negative numbers as positives, i.e. i don't want any negative notation -

=(S12-S14)

****

I would like this formula to display negative numbers as a zero, please

=(S15/S12)*W12

Hoping someone can help,

Many thanks.

[twiggywales]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[yamaha333]

Thank you ! Much appreciated, it works fine now.