Combined Custom Format for modifying decimals in a value and for hiding zeros.

[edge37]

Hello, I need your assistance, please: I have a cell with a formula that returns values with 1 decimal place:

=IFERROR((VLOOKUP($AG$10,$B$9:$Z$38,19,FALSE)),0)

I need a combined custom format where the value of "100.0" changes to just "100" without affecting the decimals of other values and also, hide zeros when cell returns a zero. I've tried some suggestions like:

[=100]0;0.0;;@

but Excel refuses to work with them.

Thank you very much.

 

[JamesCanale]

try:
[=100]0;[=0]"";0.0;

 

[edge37]

try:
[=100]0;[=0]"";0.0;

Fast and excellent! it works!. Thank you very much