Can you make it so that if a cell has any text in it then it pulls the true or false statements.
Ex. If(Sheet1!A4="any text",Sheet1!B4," ")
If sheet 1 a4 has any text in it then show line b4 on sheet 2. IF a4 is empty then pull nothing (" ").
Can you make it so that if a cell has any text in it then it pulls the true or false statements.
Ex. If(Sheet1!A4="any text",Sheet1!B4," ")
If sheet 1 a4 has any text in it then show line b4 on sheet 2. IF a4 is empty then pull nothing (" ").
=if(Sheet1!A4="","",Sheet1!B4)
or
=if(Sheet1!A4="","",Sheet2!B4)
depending on what sheet you are referring to
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks