Need to have #value return a zero value

[Malissa1578]

Good morning everyone. I am looking to see if I can adjust my isblank statement so that when it gives an error (#VALUE) it turns to a zero.

This is what I have now: =IF(ISBLANK(V40),(U40*X40),(V40*X40))

Is this possible?

 

[Joe4]

Check out the IFERROR function, i.e.

[COLOR=#ff0000]=IFERROR([/COLOR][COLOR=#333333]IF(ISBLANK(V40),(U40*X40),(V40*X40))[/COLOR][COLOR=#ff0000],0)[/COLOR][COLOR=#333333][/COLOR]

 

[Malissa1578]

Thank you. I think I was trying to complicate way more than this lol.

Check out the IFERROR function, i.e.

[COLOR=#ff0000]=IFERROR([/COLOR][COLOR=#333333]IF(ISBLANK(V40),(U40*X40),(V40*X40))[/COLOR][COLOR=#ff0000],0)[/COLOR]

 

[Joe4]

You are welcome!