Add Numbers from One or Another Cell

gebobs · #1 01-30-2017, 01:22 PM

Code:

=if(f4>0,j4+l4,if(f4<0,g4,0))

Kilch · #2 01-30-2017, 10:01 PM

Thanks gebobs Worked great. Just one correction. Had to change F4 to G4.

Again Bob, thanks a bunch.

Kilch

Quote:

Originally Posted by gebobs

Code:

=if(f4>0,j4+l4,if(f4<0,g4,0))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why do numbers show up a little lower in table cell?	HealthyStealthy	Word	2	09-06-2016 06:36 AM
counting "x" in a cell and sum the numbers in weekday	rayramirezdvm	Excel	4	04-02-2015 02:58 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
How to fill a cell with random numbers to do calculations?	zanat0s	Excel	1	06-13-2011 10:33 AM
adding numbers in same cell	jetdude68	Word Tables	1	07-20-2010 12:30 AM