Hi,
I have two columns of data arranged as shown in the sample attached.
I would like to create in column C a formula that returns a 1 under the following circumstances:
If the text in column A is Absolute or Relative and the associated value in column B is >=0
If the text in column A is Percentile and the associated value in column B is <=50
Otherwise a zero should be returned.
Can someone please suggest a solution.
Thanks!
Bookmarks