| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
=IF(A1<=-5,"Lower",IF(A1=5,"Higher",IF(A1<-5:5,"Steady")))
I'm treating the A1 entry as a number. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "sross002" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
What if a1 is a percentage?
"Russell Dawson" wrote: =IF(A1<=-5,"Lower",IF(A1=5,"Higher",IF(A1<-5:5,"Steady"))) I'm treating the A1 entry as a number. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "sross002" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
How are you producing that figure?
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "sross002" wrote: What if a1 is a percentage? "Russell Dawson" wrote: =IF(A1<=-5,"Lower",IF(A1=5,"Higher",IF(A1<-5:5,"Steady"))) I'm treating the A1 entry as a number. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "sross002" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Hi
=IF(A1<=0.5,"Lower price",if(A1=0.5,"Higher price","Steady price")) -- Regards Roger Govier sross002 wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
