Insert cap figure instead of sum

		Microsoft Office Forums > Microsoft Excel > Excel
Insert cap figure instead of sum

08-09-2018, 12:48 PM

breen77

Windows 8

Office 2010 32bit

Novice

Join Date: Jul 2016

Posts: 24

This works OK but if a cell in the calculation L7+O7 is blank it returns #value??

I still want it to return the value of cell C7

Last edited by Pecoflyer; 08-10-2018 at 08:11 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Figure number cross-referencing mess; figure numbers not updating.	seanspotatobusiness	Word	25	08-06-2018 05:00 PM
VBA to find any nine-figure number	Chayes	Word VBA	2	05-19-2017 06:06 AM
Trying to figure out this code	sharpied	Word	0	07-27-2016 12:09 PM
Caption Order: Figure 4 Figure 3 Figure 2	golfarchitect13	Word	5	05-07-2014 07:15 PM
Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc.	altjx	Word	4	06-04-2013 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:22 PM.