• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating A SUM as a negative

FranKC

New Member
Hi Guys,

This is probably really easy and i'm being daft but i need to create a sum and show the results as a negative number "ie £20.00 x 19 = -£380"

Unfortunately it is not as simple as just putting a minus in front of the £20 as it's not actually a minus number - if that makes sense.

Any help will be much appreciated.

Thanks

Fran
 
Hey FrankC,

If you need just minu sing before any number try below

1) Format cells
upload_2016-7-22_14-55-33.png

2) put formula multiply with -1

Hi Guys,

This is probably really easy and i'm being daft but i need to create a sum and show the results as a negative number "ie £20.00 x 19 = -£380"

Unfortunately it is not as simple as just putting a minus in front of the £20 as it's not actually a minus number - if that makes sense.

Any help will be much appreciated.

Thanks

Fran
 
Back
Top