if statements

For some reason, I've got a mental block today. Here's what I want to do: Cell A1 = 100000 Cell A2 = 200000 Cell a3 = 150000 (this is the variable) If cell A3 is in the range of A1-A2, then return a formula: (A3-A1) *.01 If cell A3 is greater than cell A2, the return a set number: 1000. As a...

Hi, I am trying to tell a spreadsheet to bring in a different group of values dependant on what is written in another cell. Essentially, I am trying to tell the spreadsheet to do the following: if A1="hellohello", bring in one group of numbers, if A1="goodbyegoodbye" bring in another group of...

Hello, Ive used countif and sumif statments alot but not utilizng multiple sheets usually the data and formula are all on the same sheet but i Have a worbook that has a years worth of data on it and each month has its own tab. I am creating a summary page at the front and I know i can just...

Hi I want to return a cell (U930) blank if another cell is <>0 e.g. Formula in U930 =IF(U490<>0,AVERAGE(O490:U490),"") U490 is blank, however has a similar formula which leaves it blank. This formula therefore returns #DIV/0! in U930 This there anyway around this so that U930 will be blank...

Hi! I'm looking for a way to compare the values in each column to identify the lowest number per row. I was using conditional formatting with a formula when I originally only had two columns =($A2<$B2) in column A and =($B2<$A2) in column B. Now that I have more values to compare, it isn't...

Hi all, Thanks for all you help on previous posts. I'm a young professional who uses excel often at work and its been very helpful to my development. I am currently struggling with the shortest way to tackle a project in excel. There is a set of data I have filtered based on select criteria -...

I am having issues with the following if statement. E68 is a calculated result =IF(E68<1.01,1.01,E68), IF(E68>=1.04,1.04,E68) Essentially it is <1%=1% or >4%=4% (a minimum and a maximum) Thanks for any assistance you can provide.

Hi all! Just wondering if you have any ideas what the IF statement could be for 'if the sub total is greater than 20'000, then its discount would be 10% of the total'.

In the code for a command button, I want to show different message boxes based on the option button that is selected. I can not get this code to work. Option button 1 & 2 are a group and Option Button 3 & 4 are a different group. With the code below no matter what is selected, I get MESSAGE 3...

Hello, I have a little question , on how do I highlight a certain cell like for example. <tbody> A B C D 1 FIRST NAME MIDDLE NAME LAST NAME VALUE 2 JOHN DANER CANRES 1 </tbody> as you can see table above, if the value contains "1" , the names (first,middle,last) should be highlighted...

I am trying to figure out how to sum numbers from multiple columns that match certain criteria. My spreadsheet is a funeral team tracker and it's only the 1st day of the month, Each corresponding day will eventually have it's own tab once I nail down this first one. Basically the page is laid...

Okay so below is the code. Basically what happens is that the compiler throws an "end if without block if" error and when I add an end if where required, it throws a "block if without end if" error - so what am I missing in the code then? Private Sub UpdateCommentPic(ByVal Rowno As Integer...

I'm trying to create a formula that will calculate staff entitlements based on years of service. If they have worked less than 5 years they get nothing. If they have worked between 5-7 years they get 50% If they have worked more than 7 yers they get the full 100%...

Hi, I am looping through the different sheets in a workbook and filtering by different criteria depending on the value of two different strings. There are 36 possible combinations of these string values so I need many If..ElseIf statements. However, when I have the full code I get an error...

Hello all, Need help writing and IF OR statement. In cell X3 I have an AUTOSUM that counts from 1-4 and I need cell Y3 to relay a comment based on what cell X3 returns, If 1="Received" If 2="In Progress" If 3="Testing" If 4="Completed" If blank="Awaiting" Any help is appreciated. Thanks

I'm analyzing Mechanical Turk results. Each assignment was done three times, and I want to find all sets of three assignments that were agreed upon by the majority (2/3 or 3/3) of respondents. Here's the basic setup: <tbody> NAME STATUS Org 1 active Org 1 not.active Org 1 not.active...

I am a long time reader, first time poster. I am trying to solve for how much months of supply for a product a retailer but also want it to be broken down by either the first or second decimal so if its less than 1 it it will say .77 (3 weeks of supply; now it displays 0. I would greatly...

Hello, I have a 30 row spreadsheet. Data will be entered as an employee completes a job. Column D is Job # (alphanumeric), and Column G is Amount I have a total at the bottom of Job # that counts the number of claims if the cell is not blank. I am trying to get the Amount to be 0, 20, or...

Just curious if there is a way to reduce the length of my excel formulas that are similar to the following example... =CEILING(IF(((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15>20000,20000,((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15),1000) So in essence is there a way to avoid having to rewrite the...

I'm trying to evaluate the value of 3 cells according to the following principles:1) If all 3 of the cells have the same value, all 3 are correct 2) If 2 of the cells have the same value and 1 is different, then the 2 are correct and the 1 is wrong. 3) If all 3 of them have different values all...