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 …

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

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 …

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 13, 2020 · I am working on a pricing sheet for quoting purposes. I have all the details ironed out except for one thing. I need to take the total price and multiply it by a surcharge of 9.5%. I …

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 …

Dec 22, 2005 · Why > > can I not multiply with currency? > > *VALUE! indicates that the contents of A1 are not in the expected format. In > other words, A1 contains something other than a …

Oct 10, 2007 · say c1 and d1 can have the values below, can one function contain all possibilities? (i.e. - 'x''y', 'x''l', 'x''r', 'b''y','b''l','b''r', etc.) with each condition met resulting in a …

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