multiplied

Does anyone know how to do this? Wanting to make a calculator where we input a number into a cell, say D1. IF the number falls within a particular range it gets multiplied by a particular number and the answer is displayed somewhere, say G1. If the number falls within range 6225-6725, then it...

Hi! I am trying to find a formula that will help me... not sure if anyone can help me at all pretty please!! I need something that to have a formula that will help me... So the formula would be... If cell A1 contains the word 'Joint' then cell B1 needs to be multiplied by 2, if cell A1...

Hi all, MY formula is this =IF(OR(ISBLANK(E15),ISBLANK(F15)), "", "$" &E15/F15*100 &"/100g") and my result is this <colgroup><col><col><col></colgroup><tbody> $3.20 175g $1.82857142857143/100g </tbody> Issue I'm having is I would like to only have the multiplied number to 2 decimal...

How do I modify this: =IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"") so the result is multiplied by J6 thank you in advance

Hello, I am a more or less a beginner with respect to Excel and need a little help here. I am a poker player and keep track of my winnings and losses in an Excel Sheet with diagrams etc. In essence the important part of the sheet looks something like this: <tbody> location net total...

Hey all, Sort of a novice to excel here... I'm having a huge amount of difficulty getting excel to understand what I'd like. Essentially, I want to take data I input into three separate columns and have it inputted into an equation. The equation is 0.5(4/3*(pi*a*b*c)). Four-thirds multiplied...

Hey! I am having a hard time getting a formula in 1 cell that will do what I need. Maybe it's really easy and I am just having a moment or maybe it's just not possible. Scenario: Target between 0-10000 needs to be multiplied by 0.85 THEN anything after this point needs to be multiplied by...

Hi I have this formula: =IF(SUMMARY!$E$32="INV",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.3,SUMPRODUCT($J$9:$J$15,M9:M15)/60) I know want to add in an extra formula to say that if $E$32 ="EU ",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.25 So basically 3 arguments/criteria: If a certain cell says "INV" I want...

I use a data validation to select YES or NO. When YES is selected, I want a number of product to be multiplied by the number in cell A1. When NO is selected, I want the number of product to be multiplied by the number in B1. <tbody class="SCXW137062123" style="margin: 0px; padding...

Hello guys, I have the following issue: I got Columns B with number of users added per month(Months In Column A) and in D Column I have the percentage of people that stop being users by each month that passes(For example there will be only a 92% of users that entered 3 months ago). I need to...

1) mathematically can someone tell me whats going on or the steps taken when one range of cell is selected and multiplied by another range or cells? thanks.

So the below code gets a certain period from an InputBox and posts values for each period in a spreadsheet. What I'm struggling with is applying a multipler for each year. The number of periods is typically not a full year, it's usually a partial year. For iCol = 0 To nPeriods...