Re: Value Return




Okay, try this.

=IF(ISERROR(CODE(A2:G2)),0,1)


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050
View this thread: http://www.excelforum.com/showthread.php?threadid=493233

.



Relevant Pages

  • Re: Excel file not opening
    ... If you think macros are the problem, then set your security settings to ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Value Return
    ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: What is the roundoff error in the subtraction function?
    ... Precision As Displayed) and then use a number format with 4 decimal ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: years change to current year
    ... spreadsheet using excelforum.com? ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Date function in Excel that updates only when a doc is changed?
    ... You can look at the date the file was modified using Windows Explorer. ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)

Loading