Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2021, 12:14 AM
otuatail otuatail is offline cells with triangles Windows 7 64bit cells with triangles Office 2016
Competent Performer
cells with triangles
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default cells with triangles


Why am I getting small tryangles in cells. I have 2 cells set as curancy and a third cell set as curancy =SUM(K9-K7). There should not be a problem.
Reply With Quote
  #2  
Old 06-02-2021, 10:10 AM
wiganken wiganken is offline cells with triangles Windows 10 cells with triangles Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

If you click on the cell with triangles do you see a small Diamond shape appear? If so then click on this diamond shape and a context menu should appear where you can get help to find out what is causing the triangle.
Reply With Quote
  #3  
Old 06-06-2021, 03:35 AM
otuatail otuatail is offline cells with triangles Windows 7 64bit cells with triangles Office 2016
Competent Performer
cells with triangles
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default

Okay. Thanks. Calculated cells should be protected.
Reply With Quote
  #4  
Old 06-06-2021, 06:08 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline cells with triangles Windows 7 64bit cells with triangles Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

BTW in your example the SUM function is not necessary
Reply With Quote
  #5  
Old 06-09-2021, 12:29 AM
otuatail otuatail is offline cells with triangles Windows 7 64bit cells with triangles Office 2016
Competent Performer
cells with triangles
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default

The problem is still here. I have green triangles with "The formula in this cell differs from the formulas in this area of the spradsheet.".


There is no problems with these cells.


BTW in your example the SUM function is not necessar! How else would I do this?
in the attached sheet, Cells E11, G9 and H11 do not differ from cells above or below them.
Attached Files
File Type: xlsx Excel.xlsx (122.9 KB, 7 views)
Reply With Quote
  #6  
Old 06-10-2021, 03:47 AM
Purfleet Purfleet is offline cells with triangles Windows 10 cells with triangles Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

I think the triangles come from when the sheet was created, it might be that formulas were being tested in different cells.

If you drag now the formula from the one above it then disappears
Reply With Quote
  #7  
Old 06-10-2021, 09:38 AM
otuatail otuatail is offline cells with triangles Windows 7 64bit cells with triangles Office 2016
Competent Performer
cells with triangles
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default

Yes it does dissapear which fond strange. The info is identical. I didn't test the formulas in difrent cells I simply set the cell type and entered the formular. Each day I copy the row above and paste. Then make the changes.


I have mass copied the data all the way down and then deleted them. Hopefully that should clear the problem.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
cells with triangles Converting table to text (and back) with carriage returns in cells, split and merged cells ndajko Word 5 11-04-2019 07:53 AM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
cells with triangles Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Trouble with triangles to e-mail sub folders... Emerogork Outlook 0 06-23-2011 09:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft