Excel formula questin

Excel formula questin

Post by V2F4aGF3Y2 » Sat, 06 Sep 2008 03:16:05


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

Post by Gaura » Sat, 06 Sep 2008 03:25:43

=A3*B3*0.18+0.18

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

 
 
 

Excel formula questin

Post by RHVrZSBDYX » Sat, 06 Sep 2008 03:27:01

=1.18*A3*B3

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

Excel formula questin

Post by VGVldGhsZX » Sat, 06 Sep 2008 03:29:01

=A3*B3*1.18
 
 
 

Excel formula questin

Post by V2F4aGF3Y2 » Sat, 06 Sep 2008 03:41:01

Thanks Teethless mama that formula did it!!
 
 
 

Excel formula questin

Post by VGVldGhsZX » Sat, 06 Sep 2008 03:54:01

You're Welcome!