Alternative if answer if FALSE

[sobrien1234]

I already have a formula that gives me an answer however sometimes the answer is FALSE. Where the answer comes in as FALSE I want the answer to be the cell above.

Thanks in advance

 

[mrshl9898]

What is the formula exactly?

You could say IF(*yourformula*=FALSE,*cell above*,*yourformula*), but there may be a better option.