Explain what "bring forward" means.

Also I think you have a typo because you used A2 twice with "open" returning
different results.

For the first formula maybe in A3 enter =IF(A2="open",1,"")


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 11:49:04 -0800, denise
wrote:


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