ExcelBanter - formulas

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - formulas (https://www.excelbanter.com/new-users-excel/84258-formulas.html)

las

formulas

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

Bob Phillips

formulas

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"las" wrote in message
...
how do I use a % range for instance if f13 is 25-75% in a formula

las

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" wrote in message
...
how do I use a % range for instance if f13 is 25-75% in a formula

All times are GMT +1. The time now is 11:21 PM.