I am not sure if R can read formulas and if it does, it probably as characters. I would suggest you Copy and Paste Special (as values) onto a new sheet and save it a tab delimited files.
elyakhlifi mustapha wrote: > good morning, > I have some SAS code to translate in R code and when I export data from Excel > to R I have to read formula writed as follow > > C604=(C181/S181)*(100-C182)*(100/85) > > or > > if C325=. then C740=(C346/C103)*100| else C740=(C346/C325)*100 > > I find some difficulties to write a good program to read and calculate these > formulas > there are several kinds of formulas there are with conditional and without > conditional > can you help me please? > thanks. > > > > _____________________________________________________________________________ > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.