We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel


ponytail

Likes # 0

I use excel to keep a running account of my bank acount which I print off on a regular basis but I keep getting the following pop up message and wondered what it meant. I click on the = key and then the cell I am going to deduct a amount from then I click on the - key and then the cell with the amount I am going to deduct and finally I click on the tick sign which then gives the new total.The pop up message is a small orange coloured square with a diamond shape inside with a ! sign inside that does anyone know what this means

Like this post
GroupFC

Likes # 0

Thanks VoG™ - obvious when you know where to look!

Like this post
ponytail

Likes # 0

Have not read one yet will try now

Like this post
ponytail

Likes # 0

Did not appear this time but when it happens again and it will I will click on it and come back to you all and let you know what it says.

Like this post
ponytail

Likes # 0

Hi Guys the message has just popped up again and I hovered the cursor over it and it said. The formula in this cell refers to a range that has additional numbers adjacent to it.What does that mean. I re-do it and it is fine

Like this post
Taff™

Likes # 0

So the one to untick is "Formulas inconsistent with other formulas in the region" which is under the rules section.

If you click on the information sign you will see various options, ignore being one and error checking options right at the bottom which will save you having to go through the previous method to access them.

Like this post
ponytail

Likes # 0

Hi Again taff I have unticked what you said and will now wait and see if I still get this message.

Like this post
Taff™

Likes # 0

You won't get that one again but you might get one of the others! ;0)

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

OnePlus Two release date rumours: Something's happening on 22 July

IDG UK Sites

13in MacBook Air review, Apple's MacBook Air 2014 reviewed

IDG UK Sites

5 reasons to buy an electric car and 5 reasons not to

IDG UK Sites

Evernote Skitch: the best way for creatives to doodle feedback