Applying Certain Formulas Depending On Dropdown Selection

Dec 6, 2013

Any way to apply a formula to a cell depending on what choice is made from a drop down box in a cell that it refers to.

Hypothetically:

I have a drop down box in A1 with 2 options: Cookie Making Costs - or - Cake Making Costs
In cells A3 through A10, I have cells with the costs for all the ingredients (and B3 through B10 for cake ingredients).
If I select Cookie Making Costs, I would like B1 to apply a formula that sums up all the costs associated with making cookies "=sum(A3:A10)"
If I select Cake Making Costs, I would like B1 to apply the sum of the cake ingredients "=sum(B3:B10)"

View 2 Replies


ADVERTISEMENT

3 Different Tables - VLookup Depending On Selection From Dropdown

Jun 12, 2013

I have 3 different tables on a sheet which I want to do a vlookup on depending on the selection from a dropdown.

I created the ranges I want to use in 3 cells and tried to reference the cell rather than the range. Excel no likey:

=vlookup(B2,A1,2,FALSE) instead of =VLOOKUP(B2,D1:H14,2,FALSE)

Is there anyway I can do what I am trying to do?

View 2 Replies View Related

Auto-Populate Data Depending On Selection From Dropdown List

Jan 21, 2013

How to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.

Attached files for reference :
Dropdown Month.xlsx‎
MONTHLY DATA.xlsx

View 3 Replies View Related

Single Cell Value From Either Dropdown List Or Enter Manually Depending On Selection

Jun 22, 2014

I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.

What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.

ddl.png

[URL]

Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?

I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.

View 1 Replies View Related

Applying Formulas To Large Number Of Dates

Mar 17, 2009

i have a spreadsheet with a certain data (rate of return) associated to a specific day of a year. (ex. 8-dec.-08 0.99865), and i have to calculate the rate of return (r) for every month, which is done by applying a formula (GEOMEAN) to all the rate of returns for the days of a month (ex. GEOMEAN(r[01 dec.]:r[31 dec.])).

i don't have any problems with that part. the hard part is that i have every single trading day from jan 00 to dec 08 (2000+ days), and i do not want to manually select the ranges. also, the dates do not include weekends (trading days per year = 252) which means that i cant (a) automatically determine a range or (b) automatically associate a number of days to a month (ex. oct 08 doesn't have the same amount of days as oct 07, because of the way week-ends and holidays are arranged..)

View 5 Replies View Related

Applying Formulas To An Entire Column Of Cells

Mar 20, 2007

how do I apply a formula I entered into one cell to all the cells in that column, without going through the tedious process of typing the formula in again in each cell ? I've done it before but don't remember how.

View 2 Replies View Related

Displaying Input Box Based On User Selection Of Dropdown Selection?

Jun 3, 2013

If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.

View 1 Replies View Related

Sort Depending Of Previous Selection?

Jun 12, 2014

Attached is a copy of a spreadsheet that im working on, im trying to sort staff on their correct locations depending where i originaly select them.

The attachement will have more info

View 8 Replies View Related

Select Rows Depending On Selection

Dec 5, 2008

I have a sheet with entries dated. With values next to them.

From 1/11/08 to Whenever it ends.

I would like to work out a function to select the activerow(depending on cell)
and the 30 rows under it and then print them.

Like a report almost

This could be a button or anything, no pref on it ^^

View 5 Replies View Related

How To Highlight Row Depending On Chosen Dropdown Value

Jun 25, 2013

I'm looking to use a drop-down to allow me to highlight a complete row depending on what I choose, each row is unique.

So if my drop-down is say 20 different words and I choose "Oil" I want it to look down the table and highlight the row that shows oil prices.

Example of column A might be as shown below (Starting in say A3).

(A3)Petrol
(A4)Wood
(A5)Oil
(A6)F/Fuel
(A7)Other

From my drop-down located in A1 I choose "Oil" I want it to select only row A5 and either highlight it or blank out the rest.

View 7 Replies View Related

How To Make Few Dropdown Lists Depending On One Before

Jan 7, 2014

how to make few dropdown lists depending on one before.

Example: I have table with next data: COLUMN A: (A1) Expense Type ( in all columns under A1 are types of expenses );

(A2) total trip cost;
(A3) Prize promo tour cost;
(A4 ) court renting cost;
(A5) Prize IPP cost

In columns B1, C1, D1, E1 are cities. Under each city is value for type of expense. I have uploaded worksheet for example.

Now, problem is next: I am trying to make drop down lists ( in new work sheet ) by using depending data from data table.

1.I made drop down list in first cell (let's say it is an A1 cell ) where I can chose city ( for example City of Zagreb ).

2.Then in next cell (B2) I would like to choose type of expense in drop down list ( for example Total trip cost ).

3.Finally, in C3 cell I would like to make drop down list that offers me just expense value for combination of chosen city ( Zagreb ) and chosen expense type ( Total trip cost ).

View 5 Replies View Related

Use Or Not Use Dropdown List Depending On Another Cell Value?

Aug 18, 2014

I would like to use or not use a dropdown list in data validation depending on the value of another cell. The application is to be able to choose a state from the dropdown list only if the country selected in another cell is "US". If the country is not US then I want the user to be able to fill in free text and there be no dropdown list. I know it's possible to have a dropdown list and allow entries without it being on the list but I need the dropdown list not to appear at all if the value is not US.

View 7 Replies View Related

Populate Textbox Depending On Selection From Combobox

Nov 8, 2012

Attached is my sample data.

In sheet "support data" I have two columns.

One column is a client reference and the one next to it is a client name.

On my form the combo box is populated with the client references.

When i select a reference in the combo box I would like to populate textbox1 with the corresponding client name from "support data"

(as an advanced feature it would be good if the textbox1 kept changing as the mouse was hovering over the list of client references in the combobox)

View 4 Replies View Related

Show List Depending On Drop Down Selection

Dec 18, 2006

Im currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.

When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.

if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.

View 9 Replies View Related

Dropdown List Depending On Previous Values?

Jan 3, 2013

see attached document - this is a stock record sheet. what i want it to do is when Bed is seleceted in column B - i want colum C to show the BedSize list which is in the lists tab. and the same with Chair i want it show ChairSize

View 14 Replies View Related

Changing Formats Depending On Data From Dropdown Box?

Sep 4, 2013

I have a table showing data for 10 teams. There are however 10 different measures which are pulled from a seperate sheet using a dropdown box to select the measure.

One of the measures is example 390823 which needs to be format 390,823 so that thousands are shown, and other formats are, example, 89.9 which need to be 89.9%.

Ive gone to my other sheet and all the raw data is showing correctly with % and ,s. But my dashboard table can only have one format. How do i make it so that each measure pulls in the correct format when selected, without dragging the whole area and changing each time?

View 1 Replies View Related

Formula In A Cell Value Changes Depending On Drop Down Menu Selection

Aug 19, 2014

I have created a drop-down menu combobox of districts and depending on your choice of districts the list of Health Centers in each district changes. What I want to do is to protect the contents of the cells that contain the health centers. The problem is that when I lock the cells and I choose a district, the Health Center cells cannot change because the cells are locked. Is there anyway around it?

I have attached the sample (Please look at sheet 2. The column that I want to block is the column FOSA)

View 4 Replies View Related

Using IF Function To Use Different Formulas Depending On Different Rules?

Nov 27, 2013

I have got to this stage with a formula but cannot understand why it isn't working:

=IF(OR(A2=1,A2=2),(MIN(B2:B6)+50),(MAX(B2:B6)+50))

If A2 equals 1, I want it to add 50 on to the smallest (earliest) date in C2:C5.

BUT

If A2 equals 2, I want it to add 50 on to the largest (latest) date

The formula just adds 50 on the smallest (earliest) date, whether A2 equals 1 or 2.

What am I doing wrong?

View 5 Replies View Related

Auto Fill Cells Depending On Drop Down List Selection

Sep 22, 2008

I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.

This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)

I have made drop down lists to select each of the values for the three conditions and want to show the total for them

i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.

i.e. i am away for 6 days i get 15 extra, if i am in Europe i get another 50 and if i work 12 hours i get 30.

I want to be able to calculate this total in each cell for that day.

I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.

View 12 Replies View Related

Returning One Of 2 Formulas Depending On Contents Of A Cell?

Jan 27, 2014

I have a cell in which I am entering either the letter "C" or "S".

I then want the following to happen......

If the cell contains the letter "S" do = IFERROR(VLOOKUP($B7,'Asset Growth Rate'!$A$2:$F$39,2,FALSE)*$C7,"-")

If the cell contains the letter "C" do = IFERROR(VLOOKUP($B28,'Asset Growth Rate'!$A$2:$F$39,3,FALSE)*($C28+$F28),"-")

The formulas themselves are already working in separate cells, I now just want to combine them depending on whether the cell contains S or C.....

View 1 Replies View Related

Conditional Format (with Formulas) 10 Cells Depending On 1 Criteria

Oct 19, 2009

I want to colour 10 cells (A1-J1) if I type in yes in cell K1. Using conditional formatting Im only able to colour 1 cell. Is this possible without using VBA?

View 5 Replies View Related

Assigning Certain Cell Ranges Depending On What Is Chosen In Dropdown List Of 20 Things

Jul 16, 2009

I see that IF statements can only be nested 7 times. How do I create a cell that checks to see what item was selected in the dropdown box of 20 different choices and choose a particular cell range depending on what is chosen?

View 9 Replies View Related

Dropdown List Selection

Jan 30, 2007

I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.

View 7 Replies View Related

Dropdown Menu Selection

May 1, 2013

How to create a dropdown menu to pick from two selections?

Basically, I have a 'Status' column and the status will always be 'Open' or 'Closed' and I'd like you just to be able to click a cell in that column and select one or the other.

View 2 Replies View Related

Selection From Dropdown Changes Another Cell

Nov 21, 2013

I have a a sheet with a drop down, if the selection of Critical in the drop down (A57) is selected, i need E57 to have a message saying we need to elaborate on the explanation or when critical is selected a popup with NEED TO ELABORATE in the description comes up.

View 1 Replies View Related

How To Add Equation To Dropdown Selection

Jan 11, 2014

How to add an equation to a drop down selection if you take a look at the picture in the link supplied, what I want to do is: I want the calculator to take the number in D12 then if the drop down box under it the selection is (as it is) too high then subtract 50 (k11) from D12 and display the answer in D14. I have listed the 3 drop down choices in column L, Lap 2 I would do exactly the same and so on [URL] .........

View 6 Replies View Related

Dropdown List Selection

Jan 30, 2007

I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.

View 5 Replies View Related

Row Of Data Displayed For Dropdown Selection?

Jul 27, 2014

I have created several records, each record is in it's own row. I'd like for the row to be displayed if the name of that row is selected in a drop down. How can this be accomplished? I've attached the spreadsheet to show my current progress. When a player is selected in a drop down, I would like for that players record to be displayed below the drop down.

UFC.xlsx

View 4 Replies View Related

Program For Multi-Selection In Dropdown Box

Aug 12, 2014

Having a drop down box in the document, i need to select multiple choices at the same time. VBA program for the same...attaching the file which i am working on.

View 1 Replies View Related

Default Dropdown Selection Using Macro

Dec 21, 2009

I have an excel file with a date dropdown box. The date is populated from another sheet in the same file. I need to create a macro, which will select the latest date by default when the file is opened. Is this possible and if so could someone please lead me in the right direction? I am using Excel 2003 and the date format in the dropdown box is "dd-Mon-yy" --> eg "21-Dec-09"

View 9 Replies View Related







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