Excel formula questin
 

I am trying to multiply 2 cells in a separate cell then multiply the total by
a percentage and add the percentage to get the final total in a single cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?

Excel formula questin
 

=A3*B3*0.18+0.18

is this what you are trying to do? if not, elaborate.


"Waxhawcat" wrote in message
...
I am trying to multiply 2 cells in a separate cell then multiply the total
by
a percentage and add the percentage to get the final total in a single
cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply
by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?

Excel formula questin
 

=1.18*A3*B3

Assuming that "then take the total of those 2" really means take the PRODUCT
of those two


"Waxhawcat" wrote:

I am trying to multiply 2 cells in a separate cell then multiply the total by
a percentage and add the percentage to get the final total in a single cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?

Excel formula questin
 

=A3*B3*1.18

"Waxhawcat" wrote:

I am trying to multiply 2 cells in a separate cell then multiply the total by
a percentage and add the percentage to get the final total in a single cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?

Excel formula questin
 

Thanks Teethless mama that formula did it!!


"Teethless mama" wrote:

=A3*B3*1.18

"Waxhawcat" wrote:

I am trying to multiply 2 cells in a separate cell then multiply the total by
a percentage and add the percentage to get the final total in a single cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?

Excel formula questin
 

You're Welcome!

"Waxhawcat" wrote:

Thanks Teethless mama that formula did it!!


"Teethless mama" wrote:

=A3*B3*1.18

"Waxhawcat" wrote:

I am trying to multiply 2 cells in a separate cell then multiply the total by
a percentage and add the percentage to get the final total in a single cell.
For instance i have a number in A3 and a number in B3. Then in C3 I am
trying to multiply A3 and B3 then take the total of those 2 and multiply by
18% but then have the 18% added as the final total that shows up in C3.
Can anyone help with this formula?