Previous Topic Next Topic

Help with Isblank

Closed
cjunk20 Posts 2 Registration date Friday March 4, 2011 Status Member Last seen March 4, 2011 - Mar 4, 2011 at 04:21 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2011 at 05:43 PM
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.

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2011 at 05:03 PM
you need to explain more about your problem
0
Answer 2 / 2
cjunk20 Posts 2 Registration date Friday March 4, 2011 Status Member Last seen March 4, 2011
Mar 4, 2011 at 05:36 PM
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.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2011 at 05:43 PM
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)
0