Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Subtracting two cells if there are values in them Subtracting two cells if there are values in them
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2016, 02:59 PM
josh from viauc josh from viauc is offline Subtracting two cells if there are values in them Windows 10 Subtracting two cells if there are values in them Office 2016
Novice
Subtracting two cells if there are values in them 		 
Join Date: Nov 2016
Posts: 1
josh from viauc is on a distinguished road
Cool Subtracting two cells if there are values in them
i have been working on an excel sheet where i am collecting data from a house (how much electricity it uses)

I do not get a number every day, some some cells dont have number in them.

How can i make excel subtract the lower value from the top value.


There is a value in C4, but not in C5. So i want excel to subtract cell C6-C4?

Is there a way to make excel do this automactically?

Thank


Josh
Attached Images
File Type: jpg Excel.JPG (164.5 KB, 13 views)
Reply With Quote
  #2  
Old 11-23-2016, 04:05 PM
macropod's Avatar
macropod macropod is offline Subtracting two cells if there are values in them Windows 7 64bit Subtracting two cells if there are values in them Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
=c6-c4*(c5<>"")
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-23-2016, 11:52 PM
xor xor is offline Subtracting two cells if there are values in them Windows 10 Subtracting two cells if there are values in them Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You might want to take a look at the attached.
Attached Files
File Type: xlsx kwh.xlsx (440.2 KB, 8 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting two cells if there are values in them Shortcut to haven ascending values in row/column of cells Straitsfan Excel 1 08-09-2016 05:28 AM
Subtracting two cells if there are values in them Excel cells changing values theexpat Excel Programming 5 02-27-2016 10:36 PM
Slow response updating cell values & calculated cells XL2013 kdash Excel 1 05-06-2015 10:05 AM
Subtracting two cells if there are values in them Merging cells and keeping all the data/values Holgate1967 Excel 1 11-29-2013 09:37 AM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:59 PM.

Contact Us - Privacy Statement - Top

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