Keeping formula format intact
 

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

Keeping formula format intact
 

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

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

"Michael" wrote:

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