[R-SIG-Finance] Question regarding floor and round

Gandhi, Puneet - RSCH AMRS p.gandhi at baml.com
Wed Aug 25 22:38:39 CEST 2010


Hi All,

Is there any function in R which does what Floor or Ceiling in Excel.

Excel can take 2 arguments to FLOOR function while R doesn't.

I need the following which is done in excel

Base = 0.5
Floor(126.6,Base) = 126.5
Ceiling(126.6, Base) = 127


Base = 1
Floor(126.6, Base) = 126
Ceiling(126.6, Base) = 127

I tried round, floor, ceiling, trunc in R but none does this job. 

Pls Help/Thanks
Puneet

----------------------------------------------------------------------
This message w/attachments (message) is intended solely ...{{dropped:7}}



More information about the R-SIG-Finance mailing list