if Statement

N

Nigel

I would liek to compare 2 cells and if the value is =X then have another cell
put up a message

i tried if(j24="X" andJ25="X",L18 = "You can only select 1 value",L18="")
obviously doesn't work

How would I get it to work

Thanks
 
B

BillMc

Try placing the following in cell L18: if(and(J24="X",J25="X"),"You can
only select 1 value","")
 
D

Dave Peterson

=if(and(j24="x",j25="x"),"Only one X","")

You can't assign a value to a different cell, so I'm betting you want this
formula to be in L18.
 
Top