Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sross002 sross002 is offline
external usenet poster
 
Posts: 29
Default Formula Help

I need a formula that will translate a percentage change into a word.
For instance;
if the percentage of cell a1 is negative 5% or greater I want cell b1 to
transcribe "LOWER PRICE"
if the percentage of cell a1 is 5% or greater I want cell b1 to transcribe
"HIGHER PRICE"
if trhe percentage is between -5% and +5% I want cell b1 to transcribe
"STEADY PRICE"

Thank You in advance.