IF OR FUNCTION

[TexasCPA]

=IF(T23="A",T23="B"),"CD","CR”) The result does not return a value. I get the attached error message

Open the second scree shot. If “A” is in cell T23, the value should be CD in Cell U223 and if the value is B , CR should be in Cell U23

I tried using the apostrophe as described in the error message- No result was returned.

Whats wrong with the formula?

Thanks for your help

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(T23="A","CD",if(T23="B","CR",""))

 

[TexasCPA]

=IF(T23="A","CD",if(T23="B","CR",""))

That works- Thanks

 

[Fluff]

You're welcome & thanks for the feedback.