Nested IF Statement QUESTION! PLEASE HELP!
Below is the spreadsheet I'm working with for reference:
Column A has the dates of the year, I want to use this IF statement below on the date in column B that is represented in cell B4. So if B4 is 1/6/2014 then start this IF statement on cell B9 (because A9= 1/6/2014)
=IF($B$2= "EAST",G6,IF($B$2="WEST",H6))
Not sure what additional formula is required. PLEASE HELP ME!!!
CLICK HERE FOR VISUAL
EXCEL HELP.jpg
rather than a picture - upload a sample spreadsheet
so if B4=A9 then do the IF statement - what if its does not =
=IF( B4=A9, IF($B$2= "EAST",G6,IF($B$2="WEST",H6)), " what to do if B4<>A9"
You also need a False in your IF
IF($B$2= "EAST",G6,IF($B$2="WEST",H6, "need a false here " ))
so what if B2 does not = east or west
if it can only = east or west , you dont need the 2nd IF
IF($B$2= "EAST",G6, H6)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
SAMPLE SPREADSHEET
Excel Help.xlsx
It will always be either East or West.
I want the equation to automatically put the day 1 of east or west on the cell in column B that reflects the date in column A- so if B4= 1/6/2014, I want it to put the value of G6 in cell B11.
do you mean the word east or west ?
if all you want is G6
then
=IF( B4=A9, G6, "")
put that in B11 - but i dont think this is what you want
No, I want the all of the values in column G starting with G6 to start in B11 automatically. B11=G6, B12=G7, B13=G8, etc. I want excel to know what column to use (east (g) or west (h)) and also know what row to start the data in depending on the date in B4.
So by looking at B2 (east or west) and B4 (date) excel knows to input east column into B11 because the date equals B4.
Does that make sense?
Why is this not working ?
put in B11
=IF( $B$4=$A$9 , IF($B$2= "EAST",G6, H6), "")
and copy down
That's not working.
I have around 200 items with a different starting date for every single one. I don't want to have to say =IF( $B$4=$A$9 on every single one of them.
I don't think I'm making myself clear about what I'm needing. I want the data line from column G or H to automatically start at the correct row depending on the value of row 4. So if B4 said 3/27/2014 then I want it to automatically know to start the data strand from G or H on the row where column A has the date 3/27/2014.
thank you for all of your help everyone.
sorry, I dont know how to do that , you need to find the row number and then use that information, not sure how to do that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks