Hi,
I am working on a spreadsheet in which once i have entered value from drop down menu in column 2, Column 3 gets populated
But when the Column 2 is empty column 3 shows #value!
How do i change that to Default £0
Your help will be much appreciated.
Many Thanks
Hamza
In column 3, enter =IFERROR(your formula,0) where yourformula is the formula you have in column 3.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Need more info, whats causing the issue formula/vba code?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
In your cell for Column 3 replace your formula with IFERROR(FORMULA,0)
I already have a formula in column 3 which is equal to =eval(SUBSTITUTE(I4,",","+"))
Can i not do this on a new column say column 4 and hide column 3. ?
Can't you just change that formula?
Remember what the dormouse said
Feed your head
Change that to what ?Originally Posted by romperstomper
I need that Formula to add multiple values which are in same cell
Change it to what was suggested:
=IFERROR(eval(SUBSTITUTE(I4,",","+")),0)
You could also change the eval UDF to return 0 rather than an error.
Last edited by romperstomper; 09-18-2014 at 06:43 AM.
Wrap the Excel based error trapping round the formula!
worked
wow you guys are amazing !!
There is another column
which gets values from another drop down menu in another tab
=Activity!C5
This shows 0 until a value in entered
how do i change that to blank ?
=if(isblank(Activity!C5),"",Activity!C5)
If almost worked
So it makes the values blank , but when i change it on main sheet, this one doesnt change
just stays blank
Lol is there any thing you guys cant do
lol it worked ?
The workings of the female mind, still eludes me, i struggle with that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks