## Functions

Microsoft OFFICE

### Functions

```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
Regards

```

### RE: Functions

```a place to start:

http://www.**--****.com/
--
Gary''s Student - gsnu200740

```

```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.
```

```Hello,
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:
"&TEXT(INT((_5_yr_Return_Percentile-1)/10)+1,"0")

Any help will be very much appreciated.
```

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

```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.
```

```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
```