Hi,
I am using a listbox that extracts information from 2 different colums. The information in these column is converted to a number using a string to number function. I want to multiply the information in each cell of a column with it's adjacent cell and put the result into an unused column in the listbox.
ie column 1, row 1 = 200, column 2, row 1 = 3 and i want to multiply these 2 cells together and put the result in column 3 row 1 and basically fill down from there depending on whether there is information present in cells.
Can someone show me how to do this? Any help would be most appreciated.