I am trying to make a chart that contains prices in the rows ($1.00,$5,00...)
and our 2 famous canadian taxes as the colunms ( 6% , 7.5% ) but no formulas
lets me calculate this. always says #@VALUE

Is there a formula to calculate taxes???? it doesnt accept the % or decimals

Help Thanks
--
MJ : )

It would help if you showed us the formula you are trying to use and the
values you're using in the formula. We are very, very poor mind readers.

Tryo

"MJ" wrote in message
...
I am trying to make a chart that contains prices in the rows
($1.00,$5,00...)
and our 2 famous canadian taxes as the colunms ( 6% , 7.5% ) but no
formulas
lets me calculate this. always says #@VALUE

Is there a formula to calculate taxes???? it doesnt accept the % or
decimals

Help Thanks
--
MJ : )

The usual cause of the #VALUE! error is that the cells are not numerical.

Assuming prices in column A.

In B1 enter =A1*.06 to get GST

In C1 enter =A1*.075 to get PST

If these produce the error then I would suggest that the numbers in column A are
really text.

Format all to Generl. Copy an empty cell.

Select column A and EditPaste SpecialAddOKEsc.

Any difference?


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 15:22:00 -0800, MJ wrote:

I am trying to make a chart that contains prices in the rows ($1.00,$5,00...)
and our 2 famous canadian taxes as the colunms ( 6% , 7.5% ) but no formulas
lets me calculate this. always says #@VALUE

Is there a formula to calculate taxes???? it doesnt accept the % or decimals

Help Thanks