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)