# Help with Isblank

[Closed]
Posts
2
Registration date
Friday March 4, 2011
Status
Member
Last seen
March 4, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

is there a way to use Isblank in such a way that if a cell is blank then do this formula, if not then keep the results that are already there?Pls hlp.

Related:

## 2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Posts
2
Registration date
Friday March 4, 2011
Status
Member
Last seen
March 4, 2011

I have a formula that uses other cells that also contain formulas to figure it's values monthly.
For ease sake we'll call the 2 cells that the last formula uses A1 and B1. The last formula is in cells C3:C14 and it figures monthly.

The problem is that when A1 and/or B1 changes, the results change in all the cells C3:C14. If it's already figured C3:C5 before A1 or B1 change, I want those results to remain what they were.

The actual formula looks like this:

=IF(E10>1,IF(AND(SUM(IF(E10>=\$E\$6,1,0),IF(F10>=\$F\$6,1,0),IF(G10>=\$G\$6,1,0))>=2,SUM(IF(H10<=\$H\$6,1,0),IF(I10=\$I\$6,1,0))>=1),"PASS","RETEST")," ")

Can I add an Isblank to it? I don't know what to use to tell it to keep the value that's already there