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