How can I get this formula to return a zero please

[Beanie270]

I have tried to add ISNA to this formula but it keeps saying it is too long. I never wrote this formula, however I need to update it to return a Zero and have had no luck. Hope someone can help please.


=IF(V91<=0,VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE),VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE))

 

[fredlo2008]

whats the condition for it to be zero? if error? you can try this?

=IFERROR(IF(V91<=0,VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE),VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE)),0)

 

[Beanie270]

I have tried to add ISNA to this formula but it keeps saying it is too long. I never wrote this formula, however I need to update it to return a Zero and have had no luck. Hope someone can help please.


=IF(V91<=0,VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE),VLOOKUP((IF(L$91/50-INT(L$91/50)>0.5,INT(L$91/50)*50+50,INT(L$91/50)*50)),MATRIX2,2,FALSE))[/QUOTE]



Thank you this worked perfectly - I can stop pulling my hair out.

 

[fredlo2008]

I am glad it helped