I need to calculate taxes in excel

February 2, 2012 at 08:15:29
Specs: Windows XP
I have 4 columns: base rent, sqft. tax, number of months I need gross rent
base rent x sqft x tax% / months+ gross rent
how do i add the taxes on same formula

See More: I need to calculate taxes in excel

Report •

February 2, 2012 at 10:34:31
This will add 15% to the value in A1

=A1 * 1.15

To make it more flexible, put the tax rate in another cell, e.g. B1 and use this:

=A1 * (1 + $B$1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question