HELP

[MJ]

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

 

[Tyro]

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

 

[Gord Dibben]

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 Edit>Paste Special>Add>OK>Esc.

Any difference?


Gord Dibben MS Excel MVP