A stupid question

[hunteryz]

How can i add 8% more on the column?

[TABLE="width: 500"]
<tbody>[TR]
[/TR]
[TR]

[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]item price
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1.59
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1.49
[/TD]
[TD]x
[/TD]
[/TR]
</tbody>[/TABLE]



How to show the item price column 8% more base on the original price?

=A2*108% or =A2*1.08

 

[highseas]

Hi hunteryz,

Both seem to yield the same result which is 1.72. I prefer to use 1.08, for example, when doing percentages. My two cents.

 

[Snakehips]

hunteryz,

Stupid answer....... either!!

 

[brian.wethington]

108% is equal to 1.08 incidentally both are the same as (0.08*y)+y

all should be yielding the same results for you.

 

[hunteryz]

Hi hunteryz,

Both seem to yield the same result which is 1.72. I prefer to use 1.08, for example, when doing percentages. My two cents.

thank you for reply,
when i enter, the result show "0",
Is there something wrong?

 

[hunteryz]

108% is equal to 1.08 incidentally both are the same as (0.08*y)+y

all should be yielding the same results for you.

Thank you,
But the answer show "0".

 

[hunteryz]

hunteryz,

Stupid answer....... either!!

thank you for your honest reply! Tony
I think the formula not working,
The result is "0"

 

[highseas]

Make sure the cells are not text - all the cells you are working with for the numbers.

 

[Jonmo1]

Either works fine for me as well..

Do you have any circular references? Those can stop calculations..

Excel Workbook
	A	B	C
1	item price	108%	1.08
2	1.59	1.72	1.72
3	1.49	1.61	1.61
Sheet1

 

[hunteryz]

Either works fine for me as well..

Do you have any circular references? Those can stop calculations..


Sheet1

	A	B	C
item price

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]108%[/TD]
[TD="align: right"]1.08[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1.59[/TD]
[TD="align: right"]1.72[/TD]
[TD="align: right"]1.72[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]1.49[/TD]
[TD="align: right"]1.61[/TD]
[TD="align: right"]1.61[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =A2*108% C2 =A2*1.08 B3 =A3*108% C3 =A3*1.08 <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

Hi, Jonmo1
Can i Just add 8% on A2 column? not B2, C2?