Divide result by 5

[RodneyW]

I have this formula:

=IFERROR(VLOOKUP($A8,[BannerAvails4.19.xlsx]Q2!$A$3:$FC$156,4,FALSE),"0")

which produces the result I need. Now I need to modify it so that the resulting number will be divided by 5. Nothing I've tried seems to work. Any suggestions?

Thank you in advance

 

[Joe4]

Try:

[COLOR=#333333]=IFERROR(VLOOKUP($A8,[BannerAvails4.19.xlsx]Q2!$A$3:$FC$156,4,FALSE),0)/5
[/COLOR]

Is it returning a numeric or text value?
Note: change "0" (which is a text value) to 0 and divide by 5.

 

[RodneyW]

Works perfectly, thank you

 

[Joe4]

You are welcome.