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 at 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.
>
>
>