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 …

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 …

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 …

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 …

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 …

Mar 19, 2025 · Dynamic array formula to multiply multiple column arrays by a single column array Hi. In this simple example is the result array the right way to calculate the outcome or is there …

Mar 25, 2005 · How do I format a cell for user to enter in ft and inch format such as 4'33". Then how do I multiply 2 cell together to produce square foot. Example A1=4'33" and B1=3'33" …