To cut a long story short, I have an assessment for a new job tomorrow, and will be required to undergo certain tasks in word/excel.
Its been quite some months since I last used excel, could someone please tell me the format for the formula, in order to, say, subtract one cell from another.
I know how simple it is, I just cant for the life of me remember what it is!
All help appreciated.
Cheers
=a1-b1 in that instance
more usually =SUM(a1-b1) though
biggest thing to know in excel is =sum()
look at that in help, it is the most useful thing around
Quote from: madmaxmore usually =SUM(a1-b1) though
That is totally inefficient. Why would you want to do =sum(a1-b1) when =a1-b1 is does the same!
Two other common ones are.
=countif(range, criteria)
=sumif(range, criteria,sum_range)