Thread: multiplication
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GEM GEM is offline
external usenet poster
 
Posts: 90
Default multiplication

i have a userform for a carpet company which has a combo box with a list of
available carpets. once the user selects from the list the price of that
certain carpet per sqaure metre is shown in a text box below (each carpet has
a different price per square metre) that all works fine!!!

BUT.... the user has to type in the number of sqaure metres they need (which
is fine as they type it manually), but i then need a formula to multiply
these together to get a total cost (baring in mind the prices of the carpets
are all different and the number of sqaure metres they type in will be
different each time!!!)

e.g. i need the number of sqaure metres multiplied by the price per sqaure
metre!!!

hope i have explained myself properly!
thanks