Thanks for your reply what a mean is when writing formulas that use
different functions and are nested, in what order should I use to put
these ( )

Eg =sum(a1:a4) I can understand but sometimes when creating a
formula 2 (( or 3((( are after the first function in the formula. what
I want to know is there a simplier way of knowing if these double or
treble parentheses should be put at the start or end of the formula.
Hope I have explained myself a little better