Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple Criteria IF Formula

Hi Experts   How would you do the following.  If PrimaryYearstoOUtcome is 5.0 then 5.0 if PrimaryYearstoOUtcome is 5.1 and we have a 5.0 (in data set as shown) then leave 5.1 as 5.1   if(STEMBRA...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

I think you are referring to this. What are the values expected in this table

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Amitchandak

 

I am referring to that table i am expecting the values as shown in the R Table to the left. See Below image 

 

 

 

 

 

 

i.e. 0 years is 664 and 1 is 656 and so on....