# Isblank question

#### cjunk20

##### New Member
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?

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### Scott Huish

##### MrExcel MVP
No, a cell cannot contain a formula and a value.

It will take VBA to do what you are asking.
Can you provide some specifics about what you are trying to accomplish exactly.

#### cjunk20

##### New Member
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

Replies
6
Views
257
Replies
9
Views
317
Replies
3
Views
222
Replies
4
Views
218
Replies
4
Views
171

1,191,166
Messages
5,985,051
Members
439,935
Latest member
Monty238

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back