Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] My multiply formula is not working, for two numbers The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Using VLOOKUP to retrieve number and multiply it by another value The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be ...
Re: PRODUCT function not working So I just learned that Excel treats cells as text when there is a particular function being used. The formula in that cell uses IF, VLOOKUP, WEEKNUM, and YEAR.
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. Example: I'm building an inventory spreadsheet. One column shows the quantity of material needed per unit (column C) , and another shows quantity of material in stock (column E).
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 below table based on the criteria "Blue" in column A. The formula should give the result 12, ie 2*3*2. Im familiar with the SUMPRODUCT but that will add the 3 numbers, ie 2+3+2, and I have also been messing with the PRODUCT formula and those 2 ...
multiply and round in one equation I need to take a number, multiply it by a precentage, & then round it to the nearest multiple of 5. ex: A1=142.5 B2=A1*50%, (then rounded to nearest multiple of 5) Register To Reply 03-01-2007, 12:09 PM #2 NBVC
How does one do a simple function to multiply a time (in hours:minutes i.e. [hh]:mm) by a cost per hour (i.e. $60/hour). If I have the time in one column, and the rate per hour in another column, I need the total to be the total cost (i.e. 10:50 times $60 = sum??? should equal $650.00 but I can't get the formula to work).
If cell is negative multiply by -1 formula 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 by 1. Is this possible?
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 a way of aggregating each of the 12 columns of array1, 2 & 3 before then multiplying by the single column array 4?
The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed. For the best help attach a sample workbook to your post Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to ...
