Wildcards in a nested IF

[KellisR]

Here is the formula:
=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(X2="*",X2,IF
(X2<>"*",B2)))) I don't have the 3rd claus written correctly, as
there is data (text) in X2 but the formula is returning cell B2
contents. Suggestions? Column X has many different "comments" so I
need to use the wildcard. Thanks in advance, this one has me
stumpted. Ron

 

[Aladin Akyurek]

On 2002-02-25 13:24, KellisR wrote:
Here is the formula:
=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(X2="*",X2,IF
(X2<>"*",B2)))) I don't have the 3rd claus written correctly, as
there is data (text) in X2 but the formula is returning cell B2
contents. Suggestions? Column X has many different "comments" so I
need to use the wildcard. Thanks in advance, this one has me
stumpted. Ron

Ron,

Try:

=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

Aladin

 

[KellisR]

Aladin, I tried to reply that it did not work, but I think I found the reason...

=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2)>0,X2,B2)))

rather then

=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

Thanks for pointing me in the right direction.

 

[Aladin Akyurek]

On 2002-02-26 14:14, KellisR wrote:
Aladin, I tried to reply that it did not work, but I think I found the reason...

=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2)>0,X2,B2)))

rather then

=IF(Q2="Scheduled",Q2,IF(Q2="NON-IET GRAD (SCHED)",Q2,IF(LEN(X2),X2,B2)))

Thanks for pointing me in the right direction.

Ron: They should behave alike...

 

[Jack in the UK]

Hi Aladin

Many times i see you add +0 or +1 on the end of complex formula and it makes all the difference, why does +0 make the formula work and without if fails.. puzzle me for many months.

Like multpy by + to get text to value works fine but ODD!

 

[Chris Davison]

Jack,

http://www.mrexcel.com/wwwboard/messages/22712.html