Forum Discussion

Copper Contributor

Nov 29, 2017

2 lists, 1 if

Hi everyone. I'm trying to create such an IF command, that if a certain cell is empty, nothing happens, if it has lets say "1" a certain list prepaired earlier appears, if "2" a different list...

excel

List

Deleted

Nov 30, 2017

try:

=IF(A1="";"",IF(A1=1;"list1";"list2"))

just needed the quotes, I'm assuming your formula seperator is ; and not the normal , as this worked for me.

Not sure about the next part, would need to think about it

Bartosz Heller

Copper Contributor

Nov 30, 2017

Thanks for your response. Unfortunately it did not work for me. I tried all sorts of combinations with the quotes, but I keep receiving an error. This is the formula I type in: =JEŻELI(A1="";"";JEŻELI(A1=2;"PamelaKlim2";"PKlim1")) .

"Jeżeli" is the Polish "IF"

SergeiBaklan
Diamond Contributor
Nov 30, 2017
Hi Bartosz,

Formula shall work correctly if only your A1 cell is not formatted as text. If it's in text format when you receive blank if A1 is empty and "PKlim1" for any other value.

Check in any cell =ISTEXT(A1)
- Bartosz Heller
  Copper Contributor
  Dec 01, 2017
  Ok. It's not tekst. It seems I've done something wrong in the whole thing. I think is the lists I've created. Could you walk me going through not creating a list but adding it to a specifik sheet.