if/then formulas

Looking for an if/then formula that includes a cascade effect. For example column A is pallets of beer, it holds 24 cases of 24 beers. Column b is cases (so when you open a pallet you then 24 cases) then column c has individual bottles. Once column C goes into the - (minus) I would like the...

I know I have done this before but I can't remember how. I have an ActiveX control checkbox with the linked cell in G14. I need to write an IF statement in cell H14 based on if the result is TRUE or FALSE. If G14 = FALSE then H14 = 0 If G14 = TRUE then H14 = 1 Normally I would us the formula...

Hey, I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Christian Man Straight Black Able Muslim Woman Gay White Mental...

I am creating a database for a coworker. He has various football helmets that are labeled 1-363. Each helmet has a size and we need a cell to auto populate the size when the user enters the helmet number. The problem is that the sizes of the helmets is not consistent to the helmet number...

Good morning! I'm so grateful this website is here! I hope someone out there can help me. Based on the table below, I want to create an if/then statement in the cell to the right of the Total cell subtracting all Orange values from Apple values. I know this can be done, just don't know how...

I am looking for a formula.... I have one worksheet which contains the following columns: CHARTER HIERARCHY <tbody> A B C D E F G Title ID Type Owner Status Parent Title Strategy Alpha 001 Project Bill Active Golf Strat 1 Bravo 002 Program Bill Active Delta Strat 1 Charlie 003 Project...

Hello! I am currently working on a work book to calculate Full time Equivalent needs vs our margin an revenue targets. I want to keep my workbook as clean as possible to present to upper management, so i am doing my calculations on another tab. I am looking for a way to pull in my direct cost...

Hello, I have an attendance calendar that automatically tells the date of holidays based on the year in cell: G2. I need the holidays that fall on Saturday to show the date as the Friday before, and holidays that fall on Sunday to show the Monday after. Here is the equation I have for...

Hello! I am pretty new to VBA, and I am not sure why my code is not working. I wanted to create a subroutine that changed the interior color of a range of cells to light red if the date in the cell is more than 90 older than TODAY() (to show which events are past-due), unless the cell is...

I am working with the following variables in a script I am writting: X: a single string variable A(1 - 18): an array that contains 18 strings I have a loop that cycles through a column of numbers (lets say column "B"), and sets X equal to B1, then B2, the B3, etc... I would like to add an...

Hi, How do I set an if/then statement for a result between two values? I have a value in A1 that will change periodically and I want the cells beneath it to reflect that change (this is part of a greater summation scheme that's already been set up): A1= 2 A2: if (x<1, A1, 0), this one is easy...

Hello, I have a particular set of data: AA BB AB CC CA CD DA FA FD FC I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. What would my statement look like? Thanks in advance!

First time posting! Hope this makes sense. I have a big spreadsheet of fundraising codes that I am trying to update to their new versions, dependent on what a value says in an adjacent column. As an example, if a code is currently EXET-EXGN-14, and the code next to it is EXET-00-CASH, if it...

I'm trying to find out if this is even possible. I am working on a spreadsheet that I am combining information from two other spreadsheets. If a column has a date listed (not blank), then I would like to insert the contents of a different cell (so I can do VLOOKUP on the remaining cells)...

I've been pulling my hair out all day... so I figured I should finally break down and ask someone. I keep a spreadsheet for my bills (who doesn't, I know). On it, I've always either copy/pasted the "Amount" in the applicable cell for when a bill is due, or a cell reference (in case it changes...

Hello, I have a problem that has stumped me. I would be eternally grateful if someone could help me. Problem: “total_members” value does not include people with “Name” of “AAA”. For example, in expedition #2, you can see that total members is listed as 4, when it should say 5. However, not all...

I need help with following. I need the SIZE AND COLOR to populate depending on what it says in the column A. column A will have color and size... but i need to know formula that would show this in column B and C. PLEASE VIEW THE IMAGE BELOW.

I am using Excel 2010 on a Win7 OS. I created a pivot table based on a fairly small data set (20 rows), a combination of text, formulas, percentages, numbers, etc.). In the pivot table, the values from the source sheet that are derived from If/Then formulas show up in the pivot table as...