Help with Isblank

[Closed]
Report
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
you need to explain more about your problem
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

=Isblank(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")," "),??Value that's already there??)

Thanks for any help you can give me.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
taking your example
if
c1=a1+b1
and you want to keep old value of c1 if either a1 or b1 later becomes blank, the it is not possible via formula as formula is based on those cell. Only option would be to use vba which will essential calculate the value and put the value in c1 (not the formula but the formula resuit)