Insert cap figure instead of sum

breen77 · #1 08-01-2018, 03:39 AM

now I have that working trying another formula

I have two cell working with previous formula with the 2 amounts capped.

I then want a total of the 2 amounts but if both cells have been capped I want the cap figure and not the SUM of the 2 cells.

I currently have this =SUM(T9,W9) and tried this =SUM(T9,W9,J9) but with this it caps all and doesn't add the 2 cells when needed.

any ideas please

Edit mod : this post is related to https://www.msofficeforums.com/excel...l-formula.html

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