Microsoft OFFICE


Postby QWxpLkFidWdocmFiaWVo » Sat, 18 Aug 2007 10:08:40 GMT

Is there any web site that you can help with to learn how to use IF, VLOOKUP, 
INDEX, etc Functions and all other functions. 
Thank all of u have a great JOB

RE: Functions

Postby R2FyeScncyBTdHVkZW50 » Thu, 30 Aug 2007 19:12:02 GMT

a place to start:

Gary''s Student - gsnu200740

Similar Threads:

1.Using the "if" function, the "and" function and the "or" function

I am not sure if or how to use all three in a formula. For example:

=if(b2="red", and c3="blue", d6="green")

if that makes sense at all.

2.Access function same as Excel's TEXT function???

I need to find a way to replicate what Excel does with the Text function.  I 
have two numeric pieces of data that need to sandwich some text.  The output 
would look like:

13.42% dec: 8

 In Excel, I would use:
=TEXT(_5_yr_Return,"00.00%")&" dec: 

Any help will be very much appreciated.

3.Access function same as Excel's FIND function

I need to find a way to replicate what Excel does with the Find function.
Any help will be very much appreciated

4.Access Function like Excel TRUNC function?

Is there an access function that performs the same action as the TRUNC 
function in excel?  

The round function doesn't work for my needs. Don't need to round up, just 
lose the decimals. a function to the result of a function

I wish to link three cells so that a date entered in cell G affects result of 
a fomula in F and displays an earlier date or blank if G is blank. I can do 
this using 
=if(G>1,G," ") on the next link E to F, I get    #VALUE

6. entering function results into another function

7. Using INDIRECT Function and INDEX Function

8. How to convert cell formula functions to code functions

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 35 guest