ISBLANK problem

  • Thread starter Thread starter SD
  • Start date Start date
S

SD

Hello Everyone,

I was looking out for some help in my excel sheet.

I have a formula :

=IF(ISERROR(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base data'!
J9:J12)),"",VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base data'!
J9:J12))

Now this formula obviously gets a number generated. I have put an
iserror to have a blank. Actually what I would like to do is .. where
ever the result is a zero or a blank ... I would like the cell to have
values of the cell thats is on its left . Like just it would take
the same values , do I use ISBLANK with some cell ref , I am tryin to
find out.

Would appreciate any help.

thanks
SD
 
try replacing the "" in your formula below with the cell reference to
the left of the formula.


as far as the when the result is 0 part.... try this. (notice the IF
stmt on the 3rd line.

=IF(ISERROR(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12)),"", if(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base
data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12))= 0, 0, VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!
$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12))
 
Back
Top