Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2020, 01:32 PM
SekiTimewalker SekiTimewalker is offline Microsoft 365 Word - Subtract Cells help Windows 10 Microsoft 365 Word - Subtract Cells help Office 2019
Novice
Microsoft 365 Word - Subtract Cells help
 
Join Date: May 2020
Posts: 2
SekiTimewalker is on a distinguished road
Default Microsoft 365 Word - Subtract Cells help


I'm trying to get two cells in the same row to subtract into a third cell. From looking online, I found the formula =(C23-C24). Changing it to =(N4-N2) to fit my table, I keep getting !N4 Is Not In Table. However, I did the math, and that would be the row and column ID's. Could it be because I split some columns in Row N?
Reply With Quote
  #2  
Old 05-11-2020, 03:50 PM
macropod's Avatar
macropod macropod is offline Microsoft 365 Word - Subtract Cells help Windows 7 64bit Microsoft 365 Word - Subtract Cells help Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I suggest you verify the cell addresses using the CellRange macro in the Identifying Table Cell Addresses 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/word-...addresses.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-11-2020, 04:02 PM
SekiTimewalker SekiTimewalker is offline Microsoft 365 Word - Subtract Cells help Windows 10 Microsoft 365 Word - Subtract Cells help Office 2019
Novice
Microsoft 365 Word - Subtract Cells help
 
Join Date: May 2020
Posts: 2
SekiTimewalker is on a distinguished road
Default

Thank you! That worked wonderfully.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtract from X formula? tuix Excel 4 06-27-2019 06:03 PM
vba add and subtract code phoenixmoto Word VBA 6 11-06-2018 02:06 PM
Microsoft 365 Word - Subtract Cells help Subtract value if cell contains X term Jue92 Excel 4 11-01-2016 01:45 AM
Subtract value from one cell into another otuatail Excel 3 02-01-2016 03:21 AM
Microsoft 365 Word - Subtract Cells help How to Subtract value in table, based on two different conditions nitemath2 Excel 1 06-19-2015 01:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09: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