how to add $1 to dollar column when cents column reaches 100 and then minus 100 in cents column

You'll have to include some more detail on what you're trying to accomplish, but you could use an if statement? Such as, Assuming data in C3, formula would appear in Cell D3: =if(C3>=100,C3+1.00,C3-1.00)

If data in C3 is the sum of C1:C2 and >=100 I need to subtract 100 from C3 and Add 1 to A3 which is the sum of A1:A2

Try this: Using the amounts of $1.20, $2.30 and $3.40 Column B is the Whole Dollar amount Column C is the Cents amount Cell b1 1.00 Cell b2 2.00 Cell b3 3.00 Cell c1 .20 Cell c2 .30 Cell c4 .40 In cell b5 enter the formula: =SUM(B1:B3)+INT(SUM(C1:C3)) In cell c5 enter the formula: =MOD(SUM(C1:C3),1) Both columns should be formatted at numbers with two decimal places. The cents have to be entered with the decimal place. MIKE http://www.skeptic.com/

Can column c be done without decimal places. column b works without decimal places

Look up the definition of the =INT and =MOD functions and you tell me. MIKE http://www.skeptic.com/