Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |