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 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 …

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 …

Dec 22, 2005 · number even if Excel knew how to interpret it as numeric (unlike the "Fred" example). Some ways to convert text to a numeric value (where possible) are - Select the cell, …

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 …

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 …