[R] Sequential Sum in R

vioravis vioravis at gmail.com
Tue Dec 6 19:42:35 CET 2011


I am trying to code the following excel formula in R. 

a            b          c            Result    Formula
1           10         0.1         #N/A     
IF(B2<20,NA(),C2+IF(ISERROR(D1),0,D1))
2           20         0.2         0.2        
IF(B3<20,NA(),C3+IF(ISERROR(D2),0,D2))
3           30         0.3         0.5        
IF(B4<20,NA(),C4+IF(ISERROR(D3),0,D3))
4           40         0.4         0.9        
IF(B5<20,NA(),C5+IF(ISERROR(D4),0,D4))
5           50         0.5         1.4        
IF(B6<20,NA(),C6+IF(ISERROR(D5),0,D5))
6           60         0.6         2           
IF(B7<20,NA(),C7+IF(ISERROR(D6),0,D6))
7           70         0.7         2.7        
IF(B8<20,NA(),C8+IF(ISERROR(D7),0,D7))
8           80         0.8         3.5        
IF(B9<20,NA(),C9+IF(ISERROR(D8),0,D8))
9           90         0.9         4.4        
IF(B10<20,NA(),C10+IF(ISERROR(D9),0,D9))
10        100         1           5.4        
IF(B11<20,NA(),C11+IF(ISERROR(D10),0,D10))


The variable "Result" is obtained using the excel formula shown next to it.
Column D contains the Result.

dataFrame <- data.frame(a = seq(1:10),b = seq(10,100,by = 10),c =
seq(0.1,1,by = 0.1)) 	

Can someone please help me as how to calculate the sequential sum in R given
by the excel formula??

Thank you.

Ravi

--
View this message in context: http://r.789695.n4.nabble.com/Sequential-Sum-in-R-tp4165916p4165916.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list