# formulas

1. ## formulas

how do I use a % range for instance if f13 is 25-75% in a formula

2. ## Re: formulas

=IF(AND(F13>=25%,F13<=75%),"yes","no")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"las" <las@discussions.microsoft.com> wrote in message
news:F912E1EA-9AC9-40A9-9DF5-1F18D93C4694@microsoft.com...
> how do I use a % range for instance if f13 is 25-75% in a formula

3. ## Re: formulas

Bob

I have been working on this for hours...thank you for you assistance it
worked!

las

"Bob Phillips" wrote:

> =IF(AND(F13>=25%,F13<=75%),"yes","no")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "las" <las@discussions.microsoft.com> wrote in message
> news:F912E1EA-9AC9-40A9-9DF5-1F18D93C4694@microsoft.com...
> > how do I use a % range for instance if f13 is 25-75% in a formula

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1