Keeping formula format intact

[Guest]

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

 

[Guest]

=VALUE(A1)&"+"&VALUE(B1)

Try this formula in C1 and see if it is what you are after.