if statement excel

I need an IF Statement with multiple conditions and my formula is not working: =IF(G12=<100000, IF(G12>200000, IF(G12>300000, 1, 0), 0), 0) where G12 is an actual value. It came with an error. I want: If the total number of the value reached 100,000, add one. Again, in the same cell, if it...

Hello All, I have what I think may be a "simple" IF statement function, but I'm having trouble ensuring the "variable" can be randomaly assigned" to a category (depending on the results of the IF statement). So if you take a look below I'll try to explain. I have a set of survey...

Brand new to the forum and am in the middle of building a spread sheet to manage my class's progress (I'm a teacher). Our assessment levels are changing and for each different 'level' a child receives they also receive a 'point score' for example if a child is a level 5c say, that is the...

Hi All, I have a problem where I'm trying to find a formula for the following and don't know if I need to use a V-lookup, an IF statment or something else. I'm basically trying to say ; Sheet 1 A B C 1 From To Date 2 J330 J310 10/05/13 3 J330 J310 10/05/13 4 J330...

I want something that IF cell A1 = blank AND B1 = blank then C1 would = 1 OR ELSE C1 = BLANK what would the formula be for something like that?

My spreadsheet consists of 3 different sets of data. When the number returns a certain answer the image should switch based on the range of the answer. I have sucessfully done this for the first set of data that I have but I can not get the second set to work without it messing up and not...

Hi I'm needing some help/advice. I have a table based on finder fees, whereby if someone refers me to a company they are paid a percentage of the qualification costs. For example There are 3 workshops (ranging in price) where a person/company has referred me I give them between 10 & 30% of...

I am hoping for some assistance. I have Windows 7 Home Premium with Microsoft Office 10, using Excel 2010 v.# 14.0.4734.1000 32-bit. I have a tab delineated text document I have imported into excel. I am trying to then format the data to be imported into another program. The following is an...

Hi Guys, I have hit a roadblock with my excel skills. In column A1-A70000+ I have Property ID numbers and column B1-B70000+ there are contract numbers. each property ID has up to 3 contract numbers associated with it. I need to move each contract number that matches to C1,D1,E1. if it is the...

Using a VBA (or any other method) how can I tell excel to insert a line after each group of similar cells for example a a a b b b b c c becomes: a a a b b b b c c

I am trying to fill in a table with different values as i change parameters in a performance model. When i use an "IF" statement the values correctly entered for the right conditions but then are overwritten with the FALSE value when conditions (parameters) change - this i don't want, i would...

Hello all... I have been struggling building a automated schedule for my mother. She works at a hospital and there are 8 nurses on a rotating 14 week schedule. Starting in 2012; ending in 2015 -WHAT I HAVE COMPLETED- 1st - the monthly calendar changes dates and days depending on the year...

I need to create an IF statement based on the following tip: if total hours are greater than 40, then total hours minus 40, else 0. This is what I created: <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/>...