Thread: Microsoft excel equations
View Single Post
Old 9th-April-2006, 04:24 PM   #8 (permalink)
TheTramp
The Forum Legend
 
TheTramp's Avatar
 
Join Date: Nov 2002
Location: Dundee, Scotland
Posts: 10,470
Rep Power: 6
Reputation Total: 1692
TheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to allTheTramp is a name known to all
Re: Microsoft excel equations
Quote:
Originally Posted by ducasi
How I'd do it, is have two columns off to the right with something like "=if(f10 = "paid",e10)" and "=if(f10 != 'paid',e10)" in each of them.

Then I'd sum those two column to get total paid and total owed.

That make sense?
Beat you
TheTramp is offline   Reply With Quote