Man pages for njbultman/xlsxFunctions
Use Common Microsoft Excel Functions in R
| AND | Determine if Two Conditions are Both True |
| AVERAGE | Calculates the mean value of the vector |
| AVERAGEIF | Averages Vector Components Based On Condition |
| CONCATENATE | Concatenate Vector Components |
| CORREL | Calculate Correlation Between Two Vectors |
| COUNTBLANK | Count Number of Blanks in Vector |
| COUNTIF | Count Vector Components Based On Condition |
| DAYS | Difference in Days Between Two Dates |
| EXACT | Test if Two Strings or Vectors of Strings are Equal |
| FIND | Find Character Number in String |
| FV | Calculate Future Value of Cash Flows |
| IF | Standard IF statement in Microsoft Excel |
| LEFT | Return Specified Number of Characters from Left in... |
| LEN | Count Characters in String or Vector |
| LOWER | Convert Text to Lowercase |
| NOW | Get Today's Date & Time |
| OR | Determine if One of Two Conditions are True |
| PV | Calculate Present Value of Cash Flows |
| RANDBETWEEN | Get Random Number Between Two Numbers |
| RIGHT | Return Specified Number of Characters from Right in... |
| SUMIF | Sums Vector Components Based On Condition |
| TODAY | Get Today's Date |
| TRIM | Trim Leading & Trailing Whitespace in String/Vector |
| UPPER | Convert Text to Uppercase |
| VLOOKUP | Find/Return Values From Matching Rows in Data Frame. |
