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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:30 AM.