| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIF or Sum IF Questin | Excel Worksheet Functions | |||
| questin regarding blacked out cells | Excel Discussion (Misc queries) | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Sumproduct questin | Excel Discussion (Misc queries) | |||
Hybrid Mode
