Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey Guys.
I am trying to assist my friend in creating a product list for a website he created. Essentially, he has a list of all of the products with their wholesale price. To get the final price he adds things like markup, commissions, tax, etc to get the final price. Currently, he has a separate column for each item. However, he would like to remove the columns and leave the final cell with the format intact. So for example, if the wholesale price (A1) is $10 and the commission (B1) is $1 the Final Price would be C1=A1+B1 or $11... he would like it to become C1=10+1... Can you use formulas to do this? or does it have to be VBA? Thanks for your help on this! Regards, -Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Keeping Text format | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
keeping dates in UK format | Excel Discussion (Misc queries) |