Amazon

Monday, 2 August 2010

Formula explanation

Hi People

The last post was a little lengthy and a number of new concepts (for a total beginner)

The formula which we left off at was the one below

= if (d3="";"";c3*d3)     remember that c3 is the same as C3 etc

OK, now remember that ALL calculations start with an '=' sign, so that part is standard with any calculation.

The ' if ' part is the most common way of setting a conditional calculation. The format is

=if (something is true; do this ; if false do this)
There are 3 parts to this calculation

  1. The test - in our equation we are testing if there is anything in cell d3
  2. True option - if the content of d3="" then display "" (the double quote marks with nothing - not even a space - are the same as saying nothing) so the test is saying if d3="" (nothing) then put "" (nothiing) in this cell.
  3. The false option - if the content of d3=3 (clearly there is something there now) then multiply the contents of c3 by the contents of d3 and put the result in this cell.
Can you figure out what to do for the other two  calculated columns (only g3 to g20 and h3 to h20 need to be used for the moment).

That is all this time people

Thank You
Prometheus1618



We now have a FREE SPYWARE REPORT available, yours to keep and share if you wish. Fill in your details below and get yours now

eMail address:
First Name:

No comments: