Formula Help
in [General]
|
From: sross002 on 29 Mar 2010 10:37 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.
From: Russell Dawson on 29 Mar 2010 11:04 =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.
From: sross002 on 29 Mar 2010 11:29 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.
From: Russell Dawson on 29 Mar 2010 11:32 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.
From: Roger Govier on 29 Mar 2010 15:54 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.
|
Pages: 1 Prev: Sorting whole Protected 2003 REDUX Next: Formatting a number as a date |