AutoHotkey | Android | Arduino | COMM140 | Fractals | Grammar Checkers | Knots | A Million Dots Activity | Processing | Processing for Scratch Users | RedBubble | Tutorials | Weather | World Time Meeting Planner | Favicon Generator.
Home > Tutorials
> Excel Notes
| Formulas | Examples | Use |
=CHAR(RAND()*(121-97)+97) =CONCATENATE(A3,B3,C3,D3,E3,F3) |
|
Generate Random Passwords
|
|
=VLOOKUP(F3,$U$17:$V$23,2,TRUE)
|
 |
Uses a Lookup table to convert a numeric mark to a grade. See: Markbook Tutorial
|
| =AND((TODAY()-A2)>=30,ISBLANK(C2)) |
|
Format a cell if it's over 30 days old and has not been actioned.
|
APA citation:
Russell, R. (2016, July 04, 03:39 pm). Excel Notes
Retrieved April 24, 2024, from
http://www.rupert.id.au/tutorials/excel/index.php
Last refreshed: April 24 2024. 03:34.30 am
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.
