# Get instant live expert help on I need help with ifelse function in r

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to lock a table reference in an index, match function. E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4) I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-8] when I drag the formula down
Solved by X. H. in 23 mins
Hi, I want to create a countdown to show when I go on R&R from work in Iraq. So far I have created a pie chart and separate data that shows how long I have been in country for and also how long I have left until I go on R&R using the required formulas and dates that says when I arrived in country and when I go on R&R. I would like to a function to this that shows when I have less than a month to go for R&R, with the text appearing below the pie chart stating "Less than a Month" when I have reached this time frame, and also I would like the same for when I reach a week or less. Was wondering if you could help on the matter please?
Solved by C. C. in 26 mins
Type in the R square of my model ( Hint: R square after first iteration) ?
Solved by A. L. in 20 mins
Need help with percentage rank excel. I have a formula that is finding rank even when filtered. Now I need to turn that rank into a percentage, 1-100, even when filter also. The formula for the rank is =SUM(IF(SUBTOTAL(103,OFFSET(\$R\$2:\$R\$1022,ROW(\$R\$2:\$R\$1022)-ROW(\$R\$2),0,1))>0,IF(R2>\$R\$2:\$R\$1022,1)))+1
Solved by E. J. in 24 mins
I need to enter R,A,G in adjacent cell based on original cells value Example 0 = G Between 0 and -2 = A Lower than -2 =R 0 G -1 A -5 R
Solved by K. B. in 25 mins