I would like to make a formula, that states that if a range of cells all equal "true" then it will return a content-filled cell from another sheet, into a 3rd sheet.
Sorry, if that is a terrible explanation.
Basically, i have a Screen Processing sheet with check-boxes on one sheet, which return a true or false input on a second sheet, if they have been clicked or not.
On the same sheet as that, there is a big merged cell with some content already in it.
So on a 3rd sheet, i want to be able to write a formula that basically says.
IF Cells A14-A17 are all true, then in the 3rd sheet in A1 show the content from the 2nd sheet cell K1-16 to V1-16 (merged cell)
I'm happy to clarify any questions you may have, because this appears to be as thick as mud, i'm not great at if/else, print statements, etc.
Thanks for your time and patience. Great community here.
Aucun commentaire:
Enregistrer un commentaire