I run Excel on native MS Office 2002 XP.
I am trying to define 3 conditions for analysing my data, one of which includes an interval. These are:
If A1 > 3 then A2 = 1
If A1 < 3 and > 0 then A2 = N
If A1 < 0 then A2 = 2
I am frustrated in my attempts to use MS Help because it is formatted to accept only 2 outcomes (true or false)
Thank you for you help
I am trying to define 3 conditions for analysing my data, one of which includes an interval. These are:
If A1 > 3 then A2 = 1
If A1 < 3 and > 0 then A2 = N
If A1 < 0 then A2 = 2
I am frustrated in my attempts to use MS Help because it is formatted to accept only 2 outcomes (true or false)
Thank you for you help