| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error types
last one....
How do you say if cell a1 is error type #value, then put "x"? Also how do you say if cell a1 is an error, put y? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error types
if Range("A1").Text = "#VALUE!" then
' put x where? if iserror(Range("A1").Value) then ' put y where? -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... last one.... How do you say if cell a1 is error type #value, then put "x"? Also how do you say if cell a1 is an error, put y? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error types
If Range("A1").Value = CVErr(xlErrValue) Then
Range("A1").Value = "x" ElseIf Iserror(Range("A1").Value) Then Range("A1").Value = "y" End If -- HTH RP (remove nothere from the email address if mailing direct) "Darin Kramer" wrote in message ... last one.... How do you say if cell a1 is error type #value, then put "x"? Also how do you say if cell a1 is an error, put y? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error bars types | Charts and Charting in Excel | |||
| error bar types | Charts and Charting in Excel | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| What does ISERROR look at besides the 7 Error Types? | Excel Worksheet Functions | |||
| Counting the number of Error Types | Excel Worksheet Functions | |||
Linear Mode
