Subtracting two cells if there are values in them

		Microsoft Office Forums > Microsoft Excel > Excel
Subtracting two cells if there are values in them

11-23-2016, 04:05 PM

macropod

Windows 7 64bit Subtracting two cells if there are values in them

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

=c6-c4*(c5<>"")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shortcut to haven ascending values in row/column of cells	Straitsfan	Excel	1	08-09-2016 05:28 AM
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
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:09 AM.