what function to use
 

Hi

I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.

For example

anything above 70% needs to be called fixed
anything above 50% but lower than 70% needs to be called flexible

etc
etc

Can anyone help with this please?

Thanks a lot!

Phil

what function to use
 

try
=if(a2.7,"fixed",if(a2.5,"flexible",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi

I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.

For example

anything above 70% needs to be called fixed
anything above 50% but lower than 70% needs to be called flexible

etc
etc

Can anyone help with this please?

Thanks a lot!

Phil

what function to use
 

If you had a percentage in A1, put this in B1
=IF(A10.7,"Fixed",If(A10.5,"Flexible",""))

" wrote:

Hi

I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.

For example

anything above 70% needs to be called fixed
anything above 50% but lower than 70% needs to be called flexible

etc
etc

Can anyone help with this please?

Thanks a lot!

Phil

what function to use
 

On Aug 25, 3:04*pm, "Don Guillett" wrote:
try
=if(a2.7,"fixed",if(a2.5,"flexible",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...



Hi

I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.

For example

anything above 70% needs to be called fixed
anything above 50% but lower than 70% needs to be called flexible

etc
etc

Can anyone help with this please?

Thanks a lot!

Phil- Hide quoted text -

- Show quoted text -

thanks for that!!!!!

what function to use
 

If you have many different possible options, you can also create a table with
your percents and the desired return value:

A B
..5 flexible
..7 fixed

and do =vlookup(yourvalue,A:B,2)

to return flexible for any value between .5 and .6999999999 and fixed for
values .7+
In the above example, anything < .5 would return an error, so presumably,
you'll want somethign for value 0.

"Don Guillett" wrote:

try
=if(a2.7,"fixed",if(a2.5,"flexible",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi

I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.

For example

anything above 70% needs to be called fixed
anything above 50% but lower than 70% needs to be called flexible

etc
etc

Can anyone help with this please?

Thanks a lot!

Phil