Ceroc Scotland Forum - View Single Post

**ducasi** · 9th-April-2006, 04:23 PM

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?

Edit: Steve, stop stealing my thoughts!!!!!

9th-April-2006, 04:23 PM	#7 (permalink)
ducasi Lovely Moderator Join Date: Feb 2005 Location: Glasgow Posts: 9,535 Rep Power: 6 Reputation Total: 3230	Re: Microsoft excel equations 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? Edit: Steve, stop stealing my thoughts!!!!! __________________ Let your mind go and your body will follow. – Steve Martin, LA Story