Hi -
Please see attached file - is there a way to not see the #VALUE on each line without losing the formula?
Thanks,
Una
Hi -
Please see attached file - is there a way to not see the #VALUE on each line without losing the formula?
Thanks,
Una
The reason you are getting #VALUE is because the cells you are referencing in column J aren't empty.
If you clear them out you will see results in column C.
Probably not the results you want though.
If posting code please use code tags, see here.
Change the formula as so:
Please Login or Register to view this content.
Thank you, I was tryng to make the #value "invisible" until an actual number was calculated - but that would make the number invisible too, I assume.
You have single spaces in J6, J8 etc and that's why you get the error.
If you clear those cells you could use this formulas like these to hide the result unless there was a value in J6
Formula:Please Login or Register to view this content.
Mehmetcik's response would be your best bet. It is known as "error trapping" or "error handling" and very useful once you understand it. The iserror() formula returns true if the formula it contains returns any error, therefore coupled with the "if" function, it is invaluable.
Wrap your formula like this:
=IFERROR(formulagoeshere,"")
All errors will show as blank cells.
www.excel-help.net
Thanks everyone!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks