In an excel spreadsheet I have text in a cell and numbers in other cells in
same row. I want to create a couple of formulas the first being that in cell
A2 says "open" then bring forward the number "1"

the other being that if cell A2 says "open" then bring forward the entire row

I'm not sure how to create this formula whether it would be something like a
=what if or =if