Jul 26, 2021 · Re: My multiply formula is not working, for two numbers When you select a currency cell in column 2, can you see the currency symbol in the formula bar? If so, the cell …

Jul 16, 2013 · Hi all, I need some help with a formula that would be put in column B and check if the value next to it column A is a negative and if it is to multiply it by -1, but if not just multiply it …

Aug 29, 2015 · Multiply based on criteria Hi Im trying to make a formula that will multiply all numbers in an area based on a criteria, for instance multiply the numbers in column B in the …

Dec 15, 2016 · Re: Using VLOOKUP to retrieve number and multiply it by another value It's the hourly rate column on sheet 2 that is the problem. You have added a dollar sign and spaces …

Oct 8, 2019 · Hey everyone, I'm wondering if there is a way to subtract the numbers from individual cells in two columns, and multiply them by another number in a separate cell. …

May 1, 2014 · Re: Multiplying after the decimal point. You see 35.2571, but it is 35,2571428571429 0.2571428571429 * 35= 9.000 First you divide by 35 and the you multiply …

May 3, 2006 · How does one do a simple function to multiply a time (in hours:minutes i.e. :mm) by a cost per hour (i.e. $60/hour). If I have the time in one column, and the rate per hour in …

Oct 10, 2007 · if c1 says "x" and d1 says "y" then multiply a1 by 1 if c1 says "x" and d1 says "l" then multiply a1 by 2 i can get the first statement to work with the following function: =IF …

Nov 2, 2012 · Re: Multiply 2 cells, one of which has text You will have to extract the number using a formula or two, and then multiply. Does your data follow any kind of pattern? Can you post …

Dec 13, 2020 · Re: Multiply by percentages I tried changing the cell from general to percentages but that changed to value of the cell from 9.5 to 950% I tried adjusting the decimal places but …