TOM! I recently attended your class and you gave a formula for error messages not to appear in cells. It's not working for me! I'm trying to have U3 be the result of S3/T3. When there is no data, I don't want the #DIV etc to show. I think I'm missing a parenthesis somewhere. This is the formula I put in: =IF(ISERRORS3/T3),"",S3/T3)
Thanks!
Results 1 to 3 of 3
-
New Lounger
- Join Date
- Mar 2002
- Posts
- 1
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-03-21 15:43Excel - Error Message (Excel 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Uranium Lounger
- Join Date
- Jan 2001
- Location
- South Carolina, USA
- Posts
- 7,295
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-03-21 16:17Re: Excel - Error Message (Excel 2000)
Try:
<pre>=IF(ISERROR(S3/T3),"",S3/T3)
</pre>
Legare Coleman
-
4 Star Lounger
- Join Date
- Jan 2001
- Location
- Kortrijk, Belgium
- Posts
- 571
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-03-21 16:17Re: Excel - Error Message (Excel 2000)
use =IF(ISERROR<font color=red>(</font color=red>S3/T3),"",S3/T3)
