How can I remove the #VALUE! in a cell and still retain the format and formula please
See attached wbOOK.
How can I remove the #VALUE! in a cell and still retain the format and formula please
See attached wbOOK.
Like this:
=IFERROR(your_formula,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thankyou, I was leaving the TEXT statement in the formula as well as the IFERROR. Once removed, I am OK
Glad to have helped!
I have unsolved this issue because when I remove the TEXT function and replace with IFERROR, the calculations of times do not work out
See examples in attached WB - where cells J9 and L9 uses the TEXT function, and calculates out OK, whereas where H9 has the IFERROR and then the result in H8 does not compute correctly.
Is there a way to use IFERROR and TEXT together?
Or maybe there is a smarter way to get the results In am trying to achieve?.
You have created a circular reference error in G9, I9, H5 and K9. A cell cannot (generally) reference itself...
=IF(G8<>"",IF(G9="",NOW(),G9),"")
=IF(I8<>"",IF(I9="",NOW(),I9),"")
=IF(F5<>"",IF(H5="",NOW(),H5),"")
=IF(K8<>"",IF(K9="",NOW(),K9),"")
Resolve those 1st and you may get the answer you expect
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks FDibbins
I am using the Circular References and Iterations as referred inRemoving the Circular References makes the NOW() updateall cells at the same time which I don't require.HTML Code:
I have reviewed the spreadsheet and tried to explain what I am trying to achieve in the attached WorkBook.
IFERROR Function does not work, and TEXT Function is unstable
Hope this helps with WB a solution please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks