I've attached the workbook to show what the issue is along with my formula used. How can I stop #VALUE from showing up in blank cells? It's very odd to me that the formula works perfectly when there's data there, but when it's blank #VALUE shows.
The reason it matters is because it is corrupting the SUM function at the top of my worksheet.
Here is the formula:
=IF(G5="","",IFERROR(CHOOSE(LEN(G5)-LEN(SUBSTITUTE(G5,"*","")),14,16,18,20,22),IF(LEN(G5)-LEN(SUBSTITUTE(G5,"!",""))=1,20,IF(LEN(G5)-LEN(SUBSTITUTE(G5,"@",""))=1,5,IF(LEN(G5)-LEN(SUBSTITUTE(G5,"#",""))=1,5,IF(LEN(G5)-LEN(SUBSTITUTE(G5,"%",""))=1,18,IF(LEN(G5)-LEN(SUBSTITUTE(G5,"%",""))=2,24,12)))))))+IF(LEFT(G5)="&",4,0)
Bookmarks