# Help with Isblank

[Closed]
Report

cjunk20

rizvisa1

- Posts
- 2
- Registration date
- Friday March 4, 2011
- Status
- Member
- Last seen
- March 4, 2011

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

Related:

- Help with Isblank
- Excel - The ISBLANK function - How-To - Excel

## 2 replies

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

you need to explain more about your problem

cjunk20

- 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.

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.

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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)

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)