#1




Problem with Value function
I have a column of data that contains numbers, empty cells, and cells that are empty strings set by an if statement such that the value is specified as "". If this cell is an argument to VALUE() the number is converted, the empty cell becomes a 0, but the string input results in an error. The NUMBERVALUE() works however and converts the empty string to a 0. Thus my formulae work okay since it sees a number. When I try to run this S/S in earlier versions of Excel where NUMBERVALUE is not available, it cannot find a workaround. Is there a function that will convert an empty cell to a 0. I could do multiple IFs and test for empty cell and set the value to a numerical 0, but was looking for simpler implementation.

#2




What about
=ISNUMBER(A1) 
#3




The column was left blank to indicate a quantity was not defined in the budget. This is different than saying it was defined at zero. When I calculate a deviation from this value, VALUE or NUMBERVALUE treats it as zero. But when I used a formula to set the cell value I use "" since it shows as a blank. Is there a way to set a cell value to BLANK rather than "", and then I could change my formula.

#4




Can you upload a file (click Go Advanced) which shows what you have and what you want?

Tags 
numbervalue, value_function 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Problem with function  PRA007  Word VBA  2  01132016 01:11 AM 
Word 2007 Review Function Problem  sbudaj  Word  0  10092015 12:30 PM 
Function problem  li roy  Excel  2  02182012 02:44 AM 
Checkmark function problem  todddesignr  PowerPoint  0  07292011 07:40 AM 
Search Function Problem  MageWind  Excel  2  06292011 09:46 AM 