View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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