Hi
I want to create a formula for the following conditions:
IF K11 is "NO" then 1 is displayed
IF K11 is "1" then 2 is displayed
IF K11 is "2" then 3 is displayed
IF K11 is "3" then 4 is displayed
I've tried myself but it only works if "NO" is K11, if 1-3 in K11 then the 0 is returned.
Thanks
I want to create a formula for the following conditions:
IF K11 is "NO" then 1 is displayed
IF K11 is "1" then 2 is displayed
IF K11 is "2" then 3 is displayed
IF K11 is "3" then 4 is displayed
I've tried myself but it only works if "NO" is K11, if 1-3 in K11 then the 0 is returned.
Thanks