Case Sensitive IF formula

[SuperFerret]

Hi,

I've been trying to work out how to make this IF formula case sensitive. As for example O and p mean something completely different to o and P, I think I need to use EXACT but I can't get it to work

This is the basic formula as it stands:

=IF(VP!S2="Y","Message 1",IF(AND(U2="O",Y2="p"),"Message 2",IF(AND(U2="I",Y2="i"),"Message 3","")))

Can anyone shed any light on how to make this case sensitive?

 

[JackDanIce]

Hey furry Ferret, have a look at this:

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 8pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 65px"><COL style="WIDTH: 83px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>a</TD><TD style="TEXT-ALIGN: right">FALSE</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>A</TD><TD style="TEXT-ALIGN: right">TRUE</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B1</TD><TD>=EXACT("A",A1)</TD></TR><TR><TD>B2</TD><TD>=EXACT("A",A2)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

So in your case, I think you could try:

=IF(EXACT(VP!S2,"Y"),"Message 1",rest of your stuff)

Try and see, I'm about to step away for a while, but hope it helps!
Jack

 

[SuperFerret]

Jack you are an absolute S T A R !

My finished formula:

=IF(EXACT("Y",VP!S2),"Message 1",IF(AND(EXACT("O",U2),EXACT("p",Y2)),"Message 2",IF(AND(EXACT("I",U2),EXACT("i",Y2)),"Message 3","")))

which looks to be working perfectly!

BTW, loving the Papa Lazarou quotes... you seem to like all the same shows as me! You're my wife now Dave!

 

[JackDanIce]

Yes I am a big mass of energy creating brightness!

Pffff you wish you were my wife! And my name's not Dave.. you want to buy some pegs? lol

 

[SuperFerret]

Pffff you wish you were my wife! And my name's not Dave.. you want to buy some pegs? lol

Only if they're wooden ones and not those cheap plastic ones! lol

 

[JackDanIce]

Only if they're wooden ones and not those cheap plastic ones! lol

Ferret, my the pegs I supply are crafted from the richest mahogany oak, sourced from the finest groves inside the depths of columbia, carved to nanometer precision by machinery designed with German inginuity, precission and engineering and manufactured locally to England, in Dorest. Each peg, is kissed by a sun-soaked virgin, I personally gaurentee no older than 22, certainly not a Chav and available with absolute exclusively from yours truly xx

PS I make no amends for any spelling mistakes!

 

[SuperFerret]

Ferret, my the pegs I supply are crafted from the richest mahogany oak, sourced from the finest groves inside the depths of columbia, carved to nanometer precision by machinery designed with German inginuity, precission and engineering and manufactured locally to England, in Dorest. Each peg, is kissed by a sun-soaked virgin, I personally gaurentee no older than 22, certainly not a Chav and available with absolute exclusively from yours truly xx

Sun-soaked virgin kissed pegs sound good to me, but they're difficult to find...especially sun-soaked, in the UK aren't they? I suppose it does make them more exclusive.

I think I'll have to indulge in some pegs then x

 

[JackDanIce]

Nah virgins sourced from Hawaii - gives me an excuse to get to Maui!

I'll put you down for 5 then eh?

 

[SuperFerret]

Nah virgins sourced from Hawaii - gives me an excuse to get to Maui!

I'll put you down for 5 then eh?

Good plan, wish I could find an excuse to get to Maui... maybe I could erm... see the full production process start to finish?

Yes, put me down for 5

 

[JackDanIce]

Possibly.. apart from your order for the pegs, what else do I get?