I want to do a spreadsheet that calculates 6% of column A...

[mclary]

I want to do a spreadsheet that calculates 6% of column A & inserts the total
of 6%into column B ~ then I want column A & B to toal in column C ~ is this
possible?

Like this:
Column A Column B Column C
$100.00 $6.00 $106.00

 

[Frank Kabel]

Hi
Formulas:
B1: =A1*0.06
C1: =A1+B1
and copy both formulas down

 

[Don Guillett]

With a macro, something like this.

x=cells(rows.count,"a").end(xlup).row
for each c in range("a2:a" & x)
c.offset(,1)=c*.06
c.offset(,2)=c+c.offset(,1)
next

 

[JQ]

yes it is possible.
In column B write =A1*.06 and in column C write =A1+B1. Don't forget to
format the columns as currancy.
good luck

 

[Gord Dibben]

You could skip the 6% part and enter.

=A1*1.06 in B1

But, you may want the 6% part for visual reference, so suit yourself.