If Functions
Closed
kilown
Posts
2
Registration date
Friday April 25, 2014
Status
Member
Last seen
April 28, 2014
-
Apr 25, 2014 at 12:11 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 28, 2014 at 10:39 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 28, 2014 at 10:39 AM
Hello ,
I am able to create multiple if functions ( =IF(Site1!H2="y",Site1!G2,IF(Site1!H3 ="y",Site1!G3,IF(Site1!H4="Y", Site1!G4, IF(Site1!H5="y",Site1!G5,IF(Site1!H6="Y",Site1!G6, " " ))))) ) and have it work, yet if each cell has a Y in it, it would only use the first true statement, I would like if the true is correct it would move to the next cell down and fill in the next true statement.
Can anyone please help?
Jauhn S.
I am able to create multiple if functions ( =IF(Site1!H2="y",Site1!G2,IF(Site1!H3 ="y",Site1!G3,IF(Site1!H4="Y", Site1!G4, IF(Site1!H5="y",Site1!G5,IF(Site1!H6="Y",Site1!G6, " " ))))) ) and have it work, yet if each cell has a Y in it, it would only use the first true statement, I would like if the true is correct it would move to the next cell down and fill in the next true statement.
Can anyone please help?
Jauhn S.
Related:
- If Functions
- Accessor functions c++ - Guide
- Excel functions in french - Guide
- Hard disk parts and functions - Guide
- Spreadsheet functions - Guide
- If functions with dates - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 25, 2014 at 12:28 PM
Apr 25, 2014 at 12:28 PM
Kilown, Good afternoon.
Try to use it:
Select a cell where you need to have a first answer.
=IF(Site1!H2="y",Site1!G2,"")
Copy it down.
OK.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use it:
Select a cell where you need to have a first answer.
=IF(Site1!H2="y",Site1!G2,"")
Copy it down.
OK.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
kilown
Posts
2
Registration date
Friday April 25, 2014
Status
Member
Last seen
April 28, 2014
Apr 28, 2014 at 09:28 AM
Apr 28, 2014 at 09:28 AM
Not really,
I have over 78 rows of info that i want to consoldate. meaning on "site1" there are 78 rows , i want to do is if box h7 has a Y then it will spit out the info on a different sheet , but if that box "h7" does not but H8" does then it will go to it, and so and so forth.
Also I want to make sure if to "if" functions are true ( H8 and h18 ) then H8 would populate on the new sheet lets say ( A2 ) and then H18 would sit on A3 .
I am using this for a tasking, saying if you have completed a task on this date , and its due in the next 30 days H7 would show a Y , and then if that Y is there, it will move over to a new sheet so I dont have to have people searching sheets it will be right on a single sheet and simple to read.
Jauhn S.
I have over 78 rows of info that i want to consoldate. meaning on "site1" there are 78 rows , i want to do is if box h7 has a Y then it will spit out the info on a different sheet , but if that box "h7" does not but H8" does then it will go to it, and so and so forth.
Also I want to make sure if to "if" functions are true ( H8 and h18 ) then H8 would populate on the new sheet lets say ( A2 ) and then H18 would sit on A3 .
I am using this for a tasking, saying if you have completed a task on this date , and its due in the next 30 days H7 would show a Y , and then if that Y is there, it will move over to a new sheet so I dont have to have people searching sheets it will be right on a single sheet and simple to read.
Jauhn S.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 28, 2014 at 10:39 AM
Apr 28, 2014 at 10:39 AM
Jauhn S., Good morning.
Please, save an example of your work at a free site, www.speedyshare.com, and put a link to download here.
Place some data there and manually put a data like you expect to have when the formulas are ready.
It will be easier for everyone to understand and help you.
Have a nice day.
Please, save an example of your work at a free site, www.speedyshare.com, and put a link to download here.
Place some data there and manually put a data like you expect to have when the formulas are ready.
It will be easier for everyone to understand and help you.
Have a nice day.
