Good Morning,
A little question with a formula
=INDEX(R38:W38,MATCH(FALSE,ISBLANK(R38:W38),0))
all the cells from R:38 to w:38 are blank, the formula is in x-38
The formula is working fine, and returns a value of #N/A due to all criteria being blank
Can I have the formula return another verbiage like "$0.00" instead of the #N/A?
Bookmarks