Hello Everyone,
I receive invoices that are showing a negative value in this format 25.00- in Cell F10. I convert that to 25.00 using a LEN formula *-1
to get the negative value I am after in Cell G10. The issue is that on occasion Cell F10 is 0 in which case G10 returns #VALUE!. Is there
a way to get G10 to return 0 instead of #VALUE!?
Thanks,
Dean
Please Login or Register to view this content.
Bookmarks