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

 

[Jonmo1]

Sure, try this

Type 1.08 into any available cell
Copy that cell
Highlight column A
Right Click - Paste Special - Values - Multiply - OK

 

[hunteryz]

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

I try =A2*1.08
but not working

 

[Jonmo1]

I try =A2*1.08
but not working

You can't put that formula in A2, that creates a circular reference.
A formula cannot refer to the cell that contains the formula (there are a few rare exceptions, but this isn't one of them)

You can either try my suggestion in Post #11
Or put that formula in a different cell (like B2)
Then copy that cell
Then right click A2, Paste Special - Values

 

[hunteryz]

You can't put that formula in A2, that creates a circular reference.
A formula cannot refer to the cell that contains the formula (there are a few rare exceptions, but this isn't one of them)

You can either try my suggestion in Post #11
Or put that formula in a different cell (like B2)
Then copy that cell
Then right click A2, Paste Special - Values

Thank you for your help Jonmo1 and all others

, Get the correct one
If excel can do that easier will be great.

 

[Jonmo1]

Glad to help, thanks for the feedback.