Hi everyone,
Can someone help me with this IF statement? Cell E22 is a dropdown menu, containing the word 'None', and the values 1001 to 1050. If the filter is set to for example 1010, it is working perfectly. However, if I set the filter to "None", I want no filter to be applied. Is there any way to do this? For example by setting the red x to the values 1 to 5000?
IF(E22="None";x;E22))
Thanks in advance.
Can someone help me with this IF statement? Cell E22 is a dropdown menu, containing the word 'None', and the values 1001 to 1050. If the filter is set to for example 1010, it is working perfectly. However, if I set the filter to "None", I want no filter to be applied. Is there any way to do this? For example by setting the red x to the values 1 to 5000?
IF(E22="None";x;E22))
Thanks in advance.