Hi, I'm trying to write a formula that will return a zero rather than a blank.
="TOTAL: "&TEXT(A10,"#,###")
However if the value in A10 is 0 then it returns a blank.
I'd like it to return a 0.
I've been messing around with it for 45 mins reading different internet posts and watching videos but I can't figure it out.
Is IFERROR the way to go here?
Thanks in advance.
="total: "&text(a10,"#,##0")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Wow....so simple!
Thanks a million for the super quick response and fix.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks