Numbers formula help please

Hi I'm trying to complete a spreadsheet in numbers and I’m struggling. My husband use to help me when the formulas played up but he died recently so I really need some help because I can’t work out where it’s gone wrong!

It’s a speed sheet for very simple accounts, first boxes are date supplier details then gross vat and net. Then it goes into sub heading boxes and then the last box is a ‘check’ box - Other- P so if I’ve not imputed the amount into the sub headed box correctly then the amount goes into the other P box and I can check it and realise my mistake.

what’s happening is the first sub headed box G which is sundries if I put a number in that the other P box is doubling the number and putting the amount in the box

so net £10 put it into , sundries G = £10 in the P box it will say £20 it should be £0.00 because the figures are right.

Im really struggling to see any difference in the formula and wondered if anyone can help me, before I spend another 2 hours looking at it and crying. First picture is the formula which is working the second isn’t working!

thanks

Posted on Jun 28, 2024 8:55 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 28, 2024 12:27 PM

Without understanding anything about your formula, I see it has a double -- in it near the beginning. That would be the same as a +. Are you intentionally adding rather than subtracting "sundries"?

4 replies

Jun 28, 2024 2:20 PM in response to Badunit

Oh my goodness you are amazing it worked….. thank you so very very much! I know people might be thinking seriously she shouldn’t be allowed near a Mac book!! I just couldn’t work it out why it was doing it only on sundries and not the others when the formula was the same!!

thank you so very much, I’m sending you a virtual Strawberry Victoria sponge cake to say thanks!!

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers formula help please

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.