if Statement

  • Thread starter Thread starter Nigel
  • Start date Start date
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
 
Try placing the following in cell L18: if(and(J24="X",J25="X"),"You can
only select 1 value","")
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS? 3
Changing a cell from another cell's formula 4
Combining IF statements 10
if statement with vlookup 1
Finding Values With more than 2 decimal Places 7
Help with a macro 4
Multiple IF functions 2
Follow up for Mike H or J Latham 6

Back
Top