Spreadsheet 123 Spreadsheet Software Development
Home |
About Us |
Our Services |
Software |
Spreadsheets Library |
Excel Tutorials |
Useful Links |
Site Map |
Contact Us
View an Alphabetical Listing of VBA Functions
|
String Functions: | ||||
| Asc | InStr | Mid | Str | |
| Chr | LCase | Replace | StrConv | |
| Concatenate with & | Left | Right | Trim | |
| CurDir | Len | RTrim | UCase | |
| Format Strings | LTrim | Space | Val | |
|
Numeric / Mathematical Functions: | ||||
| Abs | Fix | Rnd | Tan | |
| Atn | Format Numbers | Round | ||
| Cos | Int | Sgn | ||
| Exp | Log | Sin | ||
|
Information Functions: | ||||
| IsDate | IsNull | |||
| IsError | IsNumeric | |||
|
Date & Time Functions: | ||||
| Date | DateValue | Month | Weekday | |
| DateAdd | Day | MonthName | WeekdayName | |
| DateDiff | Format Dates | Now | Year | |
| DatePart | Hour | TimeSerial | ||
| DateSerial | Minute | TimeValue | ||
|
Lookup / Reference Functions: | ||||
| Choose | ||||
| Switch | ||||
|
Data Type Conversion Functions: | ||||
| CBool | CDate | CInt | CStr | |
| CByte | CDbl | CLng | CVar | |
| CCur | CDec | CSng | ||
|
Financial Functions: | ||||
| DDb | Mirr | PPmt | Syd | |
| FV | NPer | PV | ||
| IPmt | Npv | Rate | ||
| Irr | Pmt | SLn | ||
|
File/Directory Functions: | ||||
| ChDir | FileDateTime | GetAttr | SetAttr | |
| ChDrive | FileLen | MkDir | ||
Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.
Spreadsheet 123 Spreadsheet Software Development
See Spreadsheets for:
a.Hotel Management b.Personal Budget
c.Corporate Finance d.Rating Calculation e.Real Estate and Mortgage
f.Web Calc