Iferror with negative numbers make into 0

[B5rocksass]

Hello, I have a table with a vlookup formula that sometimes brings in negative numbers. I've been manually changing all negative numbers to show as zero, but I don't know how to rewrite the formula so that it does it automatically. Please help. My formula is:

=IFERROR(VLOOKUP($A3,'QB-REPORT'!$A:$DC,2,FALSE),"0")

 

[Momentman]

Maybe
=IFERROR(MAX(0,VLOOKUP($A3,'QB-REPORT'!$A:$DC,2,FALSE)),"0")

 

[B5rocksass]

Once again, pure genius. Thank you!

 

[Momentman]

Once again, pure genius. Thank you!

You are welcome

 

[alcalina]

Other option

=IFERROR(VLOOKUP($A3,'QB-REPORT'!$A:$DC,2,FALSE)^(1/2)^2,"0")

 

[FDibbins]

I would remove the "" from around that last 0, that makes it text and you may need to use it as a value