Want to combine celll values

[ahanmagey]

I have a sheet in which there ara $ and Cents but in the bottom i want to sum them together. How can i do that?
Attached is a sample sheet.

[tdavo]

Try putting the following fomula in cell h14

=SUM(H5:H13)+SUM(I5:I13)/100

[antoka05]

You can use the formula:
=SUM(H5:H13) + SUM(I5:I13)/100
Regards,
Antonio

[royUK]

ahanmagey, please post in the correct forum. This is not a programming question

[ahanmagey]

ahanmagey, please post in the correct forum. This is not a programming question

Yah. its true that the ANSWER is NOT. But i thought i am asking a programming question, i do not know there is that much SIMPLE way to do that. i thout it would only be corrected using some codes. Thats the only reason i asked that question in here. And yah this is my SECOND violation . sorry for that.

[ahanmagey]

You can use the formula:
=SUM(H5:H13) + SUM(I5:I13)/100
Regards,
Antonio

but one more thing
Under the "cents" i want to put two(00) zeros if the value is zero. I know if we format the cell as text it will be done but then it will create problems in the sum. and another way is to write '00 but again this is also too complicated for the users that i want to handover this sheet.

can anybody help in this

[Dav]

custom format the cents cells as 00

Is that what you mean?

regards

Dav

[ahanmagey]

custom format the cents cells as 00

Is that what you mean?

regards

Dav

Have you opened the attached doc? if i format that cents column as 00 it will be wrong. right? coz if i have written 50 cents it will become 50.00!!!!!! dats not good. this is the way i want, for 1 cents = 01, 2cents = 02, 0 cents = 00, 50 cents = 50 .like that. got it?

[ahanmagey]

custom format the cents cells as 00

Is that what you mean?

regards

Dav

Hi buddy u r correct. it worked. these days my mind is in "zero" so i cannot use it to THINK about anything. hehehe. i am tired. thannks once again.

And thanks for the Administrator for moving this thread to the where it belongs to. thank you