Originally Posted by
Bigwings
... I need to know a function ...
There's a little-known button in Excel labelled
Help.
Search on
function, maths functions, IF statements et al., and you'll get a plethora of examples. Very useful if trying to construct an auto-calculating plog as well.