Possibly nested IF statement

[Pam]

I'm new in using IF statements. I have a simple one set up to say IF(C1>D1,C1,D1). I want to expound on that farther and say also IF C1=wmc, then D1. I've tried to write it and continue to get error messages. I'm not sure what I'm doing wrong.

Please Help!

Thanks!

Pam

 

[Anne Troy]

It would help us to know what kinds of values are in C and D...

 

[Mark W.]

=IF(OR(C1="wcm",C1<D1),D1,C1)
This message was edited by Mark W. on 2002-11-01 14:19

 

[Pam]

They are numeric values with the exception of an occasionally WMC acronym.

Thanks!

Pam

 

[Mark W.]

See my reply above.

 

[Pam]

Thank You !!

It worked!!!!