Formula Help #Value on ABS

[zone709]

HI this works, but if I am returning 0 right I get #value . I would like to return nothing if there is nothing if I can


=ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,5,0)+0,0)+ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,7,0)+0,0)))*(S2)

 

[TheRobRush]

if its retuning #value its not returning 0

one of easiest fixes for #value is just start formula with If(cellwithdata="" or 0 or whatever is messn it up,"",then start your formula)

 

[TheRobRush]

or IFERROR

 

[jtakw]

Hi,

What's in S2 ?

 

[zone709]

In some cells there is nothing in S2 then some have numbers. I am just getting the #value when there is nothing in S2

 

[zone709]

ok i just did Iferror and i get zero which is a better start, but how do i retuen just blank. Nothing i dont want or need the 0?

=IFERROR(ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,5,0)+0,0)+ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,7,0)+0,0)))*(S2),0)

 

[jtakw]

Just change the 0 ( zero ) to Blank ( "" )

=IFERROR(ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,5,0)+0,0)+ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,7,0)+0,0)))*(S2),"")

 

[zone709]

Just change the 0 ( zero ) to Blank ( "" )

=IFERROR(ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,5,0)+0,0)+ABS(IFERROR(VLOOKUP(B2,'Paychex (2)'!$D$2:$Z$300,7,0)+0,0)))*(S2),"")

Thanks for the help guys

 

[zone709]

Hi back again had one more question. I added "" which works now, but is there anyway to also add "" and 0 because it picks up 0 if its zero and rather it just blank also?