IF or ISnumber ???

[CreativeImages]

The results of this function
"=(ISNUMBER(VALUE(MID(D6,LEN(TRIM(D6)),1))))" is either "TRUE" or
"FALSE", how is the code written to take action on TRUE or FALSE?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
try
=IF(ISNUMBER(--MID(D6,LEN(TRIM(D6)),1)),"Action for true","Action for
false")

 

[Bernie Deitrick]

Walt,

=IF(ISNUMBER(VALUE(MID(D6,LEN(TRIM(D6)),1))),"True part","False part")

But this is simpler:

=(ISNUMBER(VALUE(RIGHT(TRIM(D6),1))))

or

=IF(ISNUMBER(VALUE(RIGHT(TRIM(D6),1))),"True part","False part")

In VBA:

If IsNumeric(Right(Application.Trim(Range("D6").Value), 1)) Then
MsgBox "It's True"
Else
MsgBox "It's False"
End If

HTH,
Bernie
MS Excel MVP

 

[Dave Hawley]

You could shorten to:

=IF(ISNUMBER(MID(D6,LEN(TRIM(D6)),1)+0),"True Part","False Part")

Or even

=IF(ISNUMBER(RIGHT(D6)+0),"True Part","False Part")

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Otto Moehrbach]

What do you mean by "take action"?
What do you want to happen when it's True? False? HTH Otto