Multiply Dependent One Cell Formula

Aug 8, 2006

All to occur in cell G2

Condition 1.
If F2 is > 0 then multiply F2 by D2.

Condition 2 in the same cell.
If the product of F2 multiplied by D2 is > E2 AND the sum of F2 and F1
multiplied by D2 is > 0, then add the product of D2 multiplied by the sum of
F1 and F2 to E2, otherwise input E2

Condition 3 in the same cell.
If the product of F2 multiplied D2 is < E2 BUT the sum of F2 and F1
multiplied by D2 is > 0, then input the product of D2 multiplied by the sum
of F1 and F2.

Condition 4 in the same cell.
If F2 < 0, and the sum of sum of F2 and F1 multiplied by D2 is < 0, then 0.

This is the best way I could think of the write out my intention. I think if
I can get the above scenario into a one cell formula that should resolve my
pain.

View 11 Replies


ADVERTISEMENT

Formula For A Cell Contains Specific Character Then Multiply By Another Cell

Feb 17, 2014

Can I get a formula for the below specification.

if a cell contains character A THEN multiply by cell B * 0.02,if a cell contains character B THEN multiply by cell B * 0.05,if a cell contains character C THEN multiply by cell B * 0.010

View 1 Replies View Related

Excel 2000 - If A1 Equal Or Less Than 1000 Multiply By B1 Otherwise Multiply By C1

Oct 30, 2013

Excel (2000), what formula would I use to accomplish the following?

If A1 equal or less than 1000 value, multiply by B1, otherwise multiply by C1.

View 9 Replies View Related

Multiply & Round Formula

Mar 21, 2008

I am having a calculating issue with a formula I'm trying to use.

What I am trying to do is to multiply the " sum of one cell" with "another cell" for a total.

The following are the cells and data involved.

A12 = 93 C12 = $44.76

A19 = 93 C19 = =sum(C12*0.05) D19 = =sum(A19*C19)

The formulas looked pretty straight forward. My problem is the total I got in D19 was not what I calculated on a calculator. C19 is $2.24 and the above formula gave D19's total as $208.13 but the calculator's total is $208.32.

I can't figure out what is causing the different totals. If there is another formula I should use for this.

View 5 Replies View Related

Multiply 2 Columns When Another Formula Exists To Add In?

Aug 22, 2014

So I have the first part of my equation and it works fine. The equation is in Column D.

=IF(ISERROR(FIND("Van",A7,1)),"",B7*C7+50)

What I want it to do is: Combine the above for Col D with: if the Unit Name Column (A) says anything EXCEPT Van, I want it to multiple Cost (Col B) by QTY (E) and put the total in Col D.

View 7 Replies View Related

Complex VBA / Formula To Multiply Values

Aug 9, 2012

I have a complex request which I think can be done either via vb or a macro, not sure which is best?, will try to explain:

The table shows a list of items that make up various BOM. there are quantities of each item required at the different BOM level

0 = Top level
1 = Level Below
2 = Level below that etc, etc

If the top level (0) has a quantity greater than 1 then all the items at the lower levels should be multiplied by that quantity

THEN move to the level 1's and whatever the quntity is in the level 1 field, multiple all lower levels by that number
if the quantity fields are blank, then always multipy below by 1

This needs to continue on down the chain of levels

So basically you end up with the correct quantites of each item at each BOM level.

View 9 Replies View Related

Formula To Multiply Single Value By Array Then Sum?

Mar 29, 2013

I am looking for an excel formula that will allow me to perform the following logic: if a cell value in (M3:BA3)="D" then multiply C29 by the corresponding value in (M29:BA29), then sum all of the products.

View 2 Replies View Related

Excel 2010 :: How To Multiply GB In Formula

Aug 11, 2013

I have Excel 2010. I am creating a spreadsheet for server backups. I have always been told to take the current size of the disk and multiply it by 10% to figure out the backup size needed for the backup. I am trying to create a formula to do this. I have a server with 25GB. The formula i tried was

=a1*10%. A1 being 25gb. Excel does not like the GB in the cell also this is only giving me the difference. I need to know what size to allow for my backup on this server.

View 9 Replies View Related

Multiply Column - Final Formula For This Spreadsheet?

Jul 30, 2014

I am having trouble with the final formula for this spreadsheet.

I want to be able to select "Holiday/Sunday" from the drop down men in column H, and have it multiply the total in column F by 2. There is already a formula in column F that sums column E-D.

View 4 Replies View Related

Match/Index Formula :: Multiply Last 3 Cells In A Row And Subtract 1

Sep 23, 2009

I am having a little trouble with multiplying a few formulas. I am looking for a formula that will multiply the last three cells in a row that contain data and subtract 1. Below is an example of the type of data I am working with and the formula I am trying to use but is not working. The formula is for the cell highlighted in red. Every quarter the last three cells being referenced will change.....

View 9 Replies View Related

Sumproduct Formula: Multiply Monthly Values With A Maximum Value In Any One Period

Jun 16, 2009

Need the formula to multiply monthly values with a maximum value in any one period? The sample file attached explains it better.

View 2 Replies View Related

Dependent Formula With Value Range?

Jan 27, 2014

how to make make cell D4 dependent on the value in cell D3. So if cell D3 = 10 (it's max), then cell D4 could equal 0-10. I want to use this in conjunction with Solver so that D4 is a variable, but can't be greater than zero until D3 is maxed out. I've already tried different formulas, but I'm not very good at writing them and data validation didn't seem to work either.

View 2 Replies View Related

Dependent Drop Down List With DEPENDENT DEFAULT VALUE

Jan 22, 2010

Situation:
I have two drop down lists 1) Country and 2) States/province

Country has list: [US, Canada]

If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list

Scenario:
First, I select "US" and choose the states to "Florida"
Next I change the country to "Canada" and forgot to choose province
Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
BUT the current value is still "Florida"

Probem:
Now I have "Canada" and "Florida" selected in the sheet

Question:
If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?

View 11 Replies View Related

Move Formula Dependent On IF Statement

Apr 15, 2014

In the attached spreadsheet, I have data pertaining to the amount of money raised for a bunch private equity funds, and the dates when this money was raised.

For a little background, private equity funds raise money in various batches or "closes", so a fund may initially raise $5M in its "first close" and then in its "second close" it may raise another $5M or so. And then a "final close" would be the last time that fund would raise money.

I'm trying to figure out a way to move data in my "Fund Size" and "Fund Size Date" columns to the corresponding "First/Second/Final" close amount/date columns, according to the "Status" of the fund in my Column A.

Essentially, if a fund is either "Fundraising" or "Fundraising and Investing" status, then I would need the fund sizes and fund size dates to populate in the corresponding columns left to right.

And then if a fund is in "Investing" status, the most recent values (or those furthest right) would need to appear in the "Final Close" columns.

Fund Closes.xlsx‎

View 5 Replies View Related

Formula Type Dependent On Another Results

Sep 6, 2006

I want to create a formula, the formula has to be dynamical.

e.g.:

A1 holds the nr - 5
A2 holds the nr - 8

Depending a solution of a sum, my answer is 1 or 2. This nr (1 or 2) is located in cel B1.

In cel D1 i want to have the numer 5 or 8 depending the previous answer. I want to use a code like this: A($B1), if B1 = 1 than cel D1 formula would be A(1) and has the value 5.

View 8 Replies View Related

Formula Dependent On Variable Range

Aug 9, 2007

I've developed a code to load csv files in excel and do some formatting on it. In addition I want to add a few cells which calculate making use of the data in the file. The data tabel (resulting after the csv import) always has the same number of columns, but the number of rows varies depending on the imported file.

My problem now is that I need to change the formula for my calculation depending on this number of rows.

This is what I got so far (not including the csv import):

Option Explicit

Dim varRow As Double

Function fctCountNrRows() As Double
Range("A1").End(xlDown).Select
varRow = Selection.Row
End Function

Sub subAddTotals()
fctCountNrRows
Cells(varRow + 2, 1).Select ..............

View 9 Replies View Related

OR Function: Multiply The Cell

Oct 24, 2009

I have a row where C5 is the total of C1:C4. What I am trying to do is if C1 or C2 or C3 or C4 has a number value that I can multiply the cell in question by 2 and then add up all of the cells to give a total in C5. Also, I have a name in A1, but when I select E1 and enter =A1 into the cell then return, I get A1 in the cell instead of the name in A1.

View 5 Replies View Related

VBA Multiply Only If Cell Is Not Blank?

Jul 14, 2014

I need a VBA macro to multiply column E and F and deposit the result in column G. The multiplication should only happen when there is a value in the column E. If there is no value in the column E, then the cell in the G column should stay blank.

View 9 Replies View Related

Multiply From Data In Cell On Sheet2 From Cell On Sheet1

Sep 18, 2012

I have a value in a cell in Sheet2 (in this case its price per ft), on sheet1 is where I would input the number of feet. So can I multiply from data in cell on Sheet2 from cell on Sheet1and if so....

View 6 Replies View Related

Formula Dependent On Text In Adjacent Column

Oct 7, 2009

I have a datatable which has a column containing up to 25 different text codes (which are currency pairs). I need to insert a specific number (as seen in the attached example) in a second column. This number depends on the text in the first column. I suspect this is very simple but at the moment, not for me!

View 3 Replies View Related

Multiply The Cell Value Inside A With Range

Feb 21, 2008

After formating I need to multiply by 2 . As you can see my Cells.Value = Selection.Value * 2 is not correct. How can I accomplish this?

With Range("I17:I4000", Range("I" & Rows.Count).End(xlUp)).Offset(, 1)
.Formula = "=ReplaceChar(I17)"
.Value = .Value
Selection.NumberFormat = "0.00"
Cells.Value = Selection.Value * 2
End With

View 9 Replies View Related

Multiply Cell Without Copying Cell Formation

May 16, 2014

I want to use the little dot in down right corner of the cell to copy the cell content and the formula correctly.

But now the problem: every time I use it also copies the cell formation.... Is there a way that it only copies the content, but not the formation?

View 5 Replies View Related

IF Formula - Column To Show Text Value Dependent On Combination Of Three Columns

May 12, 2014

I have three columns that each have a drop down of text options; column A has three options, column B has three options and column C has two options. I want to have a fourth column that will show a text value dependent on the combination of the three columns.

It ends up being 18 variations so my IF formula just won't compute.

This is basically the format I have and works for a few values then just chucks up an error when I extend it to all 18 variations:

IF(AND(A1="text",B1="text2",C1="text3"),"show this text",
IF(AND(B1="other",B1="other2",C1="other3"),"then show this", ) etc etc

Any way I can get this to work for all 18 possible outcomes??

View 6 Replies View Related

Multiply By Info In Different Columns - Selected By Input In Cell

Mar 19, 2014

I'm trying to make a sheet to calculate my taxes. I would like to keep tax rates from previous year(s), and have them applied based on which year I input in a cell..

Let say that in cell B1 I write year 2013

In cell G1 I have year 2013 and in cells G2:G7 I have tax rates from year 2013.
In cell H1 I have year 2014 and in cells H2:H7 tax rates from year 2014

In cell B17 to B20 I would like to make a formula that multiplies cell B11 or B12 with information found in either column G or H based on input in B1.

I have attached a spread sheet as example.

I know I can make a formula based on IF(B1=2013;G*;IF(B2=2014;H*;etc..

View 3 Replies View Related

Single Cell Two Numerical Values - Multiply In Different Columns

Jun 27, 2014

I am looking for formula , single cell two numerical values , multiply in different columns

example :

Cell (A1) contain: =350,23+25,59 (two values in a single cell)

request:

in (B2) only first value so 350,23 multiply (x) by fixed number &in (C2) only second value so 25,59 multiply (x) by fixed number

View 2 Replies View Related

If A1,A2orA3 Is Greater Than 0 Then Multiply By 2 Or Leave The Cell Blank

Jan 14, 2010

=IF(OR(A1>0,A2>0,A3>0),*2,"")

if A1,A2orA3 is greater than 0 then multpy by 2 or leave the cell blank

View 9 Replies View Related

Multiple Cell Formatting (number Less Than 10 Multiply By 1000)

Feb 11, 2010

How can i format a column of cells so that if a number is less than 10 for eg that that particular cell is then multiplied by 1000.

View 9 Replies View Related

Copy / Paste From Cell In One Sheet To A Cell In Another Dependent On Selection Of Dropdown Menu

May 31, 2012

I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this.

Sheet 2 "Competencies" is just data. It stores competencies with their associated definitions and questions.

Sheet 1 "Control Page" is the sheet where the questions will eventually go. The user (Interviewer) will input data on the first two pages which will include name of candidate, date of interview etc. but they will also select 5 Competencies from the already existing drop down menus on page two. From there as the selections are made I wish for a code to copy the corresponding definition on sheet 'Competencies" to cells lower down in sheet "Control page".

I don't see a place to upload a file as I have a sample of the sheet ready to go.

View 2 Replies View Related

Disable/enable A Cell Based On A Condition Which Is Dependent On Other Cell Data

Jan 26, 2007

how can we disable/enable a cell based on a condition which is dependent on other cell data

View 4 Replies View Related

Setup Dependent Cell Based On Contents Of Independent Cell

Oct 20, 2013

I'm trying to set up a dependent cell (B) based on what is in the independent cell (A)

If A is blank, B should be blank

If A has any value other than X, B should display a set string Y

If A contains X, B should contain a drop down list with a range of choices.

I've tried setting it up as a dependent validation cell and I've tried using OFFSET, but the best I can do is to get three different drop down lists to populate cell B. One with only string Y, one with only a blank, and one with the range of choices. The problem is in the first two cases above, I want the cell to fill automatically with either blank or string Y -- I don't want them to just be drop down options, with the cell displaying the last value that was input.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved