Any1 wat post in som excel and access formulas

[a_zn_911]

PLZ lik vlookup

[cobby]

I don't quite understand what your asking here...

But some common functions used in excel are:

SUM
MAX
MIN
VLOOKUP
AVERAGE
IF
OR
AND
ROUNDUP/DOWN

[kempa]

Excel functions
Vlookups
•   =Vlookup(what value will be checked against the lookup table, where the table is located, the number of columns it has)
 
Absolute cell references
•   Put a $A$12
•   So put dollar signs before! References

Count function
•   Will only return the number of cells that have something in them
•   Example     =COUNT(A19:A30)

IF functions
•   Example =IF(A2>50,”yes”,””)
•   In words this means if A2 is greater than 50 put yes, but if not leave blank
 
Max Function
•   Used for when you need to solve the maximum number of something in a record over consecutive cells
•   Example
o   Calculate the maximum number of dogs sold over 4 weeks
•   =Max(C2:F2)

Average Function
•   Example
o   Find out how much hot dogs are needed next week based on the previous 4 weeks
•   =Average(C2:F2)

[a_zn_911]

thx kempa

[excal]

Not sure if you need to know, but rounding functions

=ROUND(var, dp)

Pretty self explanatory -> =round(3.5, 0) returns 4, =round(3.56,1) returns 3.6

This function follows the rules of rounding that I'm sure you're familiar with in maths.

There are also two 'forced' direction rounds - floor and ceiling - appropriately named for round down and round up. Both take in the same variables (but are very different to the round() function):

=FLOOR(var, significance)
=CEILING(var, significance)

Unlike the round's d.p. variable, it takes in the level of significance that the rounding is done at. It's a bit of a hard concept to grasp, so do experiment with it. Generally, though, you'll be working with significances that are in base 10 (10^n).

i.e.,

=floor(4.5, 1) returns 4
=ceiling(4.67, 0.1) returns 4.7
=floor(15,10) returns 10
=ceiling(45, 100) returns 100

But to illustrate what happens in different 'bases':

=floor(4, 3) returns 3
=ceiling(4, 3) returns 6
=floor(8, 3) returns 6
=ceiling(8, 3) returns 9