Thread: if Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel Nigel is offline
external usenet poster
 
Posts: 141
Default if Statement

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