# 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
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.

Jauhn S.

## 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
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
kilown Posts 2 Registration date Friday April 25, 2014 Status Member Last seen April 28, 2014
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.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 28, 2014 at 10:39 AM
Jauhn S., Good morning.