PureCrazed
New Member
- Joined
- Oct 7, 2005
- Messages
- 30
Ok, here is the situation. I have one cell that is "dollars" and another cell that is "cents". I'm adding a couple rows together and getting a total at the bottom. Problem is that I need a formula that takes anything over 99 cents and make it go to the cell next to it as a "dollar". Here is what I got.
E9 = .20
E10 = .20
E11 = .20
E12 = .30
E13 = .20
That makes E14 = 1.10
I want my cell (E14) to read as ".10" and have those 100 penny's move over to the cell "D14" as 1 dollar. This is the formula I created that I think will work but I'm having a problem taking the amount and moving it.
=SUM(IF(SUM(E9:E13)>99,HERE,SUM(E9:E13)))
This formula will show whatever the amount is IF it is under 1.00 but where I put HERE is where I know I could put something to take the amount and show the ".10" and take whatever is over and put it to the other cell (D14).
Does that make sense?
E9 = .20
E10 = .20
E11 = .20
E12 = .30
E13 = .20
That makes E14 = 1.10
I want my cell (E14) to read as ".10" and have those 100 penny's move over to the cell "D14" as 1 dollar. This is the formula I created that I think will work but I'm having a problem taking the amount and moving it.
=SUM(IF(SUM(E9:E13)>99,HERE,SUM(E9:E13)))
This formula will show whatever the amount is IF it is under 1.00 but where I put HERE is where I know I could put something to take the amount and show the ".10" and take whatever is over and put it to the other cell (D14).
Does that make sense?