negative and poitive numbers

[j0SAND]

Finding a formula to give numbers a negative sign ie ; making 72, -72.

[Fluff13]

How about

Please Login or Register  to view this content.

[CheeseSandwich]

Maybe the below in cell J5:

Please Login or Register  to view this content.

[j0SAND]

It works great however in my explanation i forgot that sometimes there is no score returned. Your formula returnes a -72 in cells with nothing in them. My mistake, sorry to waste your time.

[j0SAND]

This does not work for me. Perhaps because of location .

[Fluff13]

Maybe

Please Login or Register  to view this content.

[j0SAND]

This now works well having changed commas to semi colons. Many thanks.

[Fluff13]

Glad to help & thanks for the feedback.