| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column to show certain percent positive AND negative
I have a spreadsheet and it shows in a column a percent. I want it to show me
*** in the clumn next to it if it had a 15% change or more. Otherwise just left blank. I am using this formula and it's only giving me *** in the column that has a positive 15%. I want it to show the *** for a positive (increase) or negative (decrease) 15% =IF(+U2600.08,"***","") Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column to show certain percent positive AND negative
=IF(ABS(U260)0.08,"***","")
or =IF(ABS(U260)8%,"***","") will show *** is U260 is greater than ±0.08 or 8% For 15% use =IF(ABS(U260)15%,"***","") The + sign in your formula was not required best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jerid B" wrote in message ... I have a spreadsheet and it shows in a column a percent. I want it to show me *** in the clumn next to it if it had a 15% change or more. Otherwise just left blank. I am using this formula and it's only giving me *** in the column that has a positive 15%. I want it to show the *** for a positive (increase) or negative (decrease) 15% =IF(+U2600.08,"***","") Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column to show certain percent positive AND negative
PERFECT!!! Thanks so much!
"Bernard Liengme" wrote: =IF(ABS(U260)0.08,"***","") or =IF(ABS(U260)8%,"***","") will show *** is U260 is greater than ±0.08 or 8% For 15% use =IF(ABS(U260)15%,"***","") The + sign in your formula was not required best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jerid B" wrote in message ... I have a spreadsheet and it shows in a column a percent. I want it to show me *** in the clumn next to it if it had a 15% change or more. Otherwise just left blank. I am using this formula and it's only giving me *** in the column that has a positive 15%. I want it to show the *** for a positive (increase) or negative (decrease) 15% =IF(+U2600.08,"***","") Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column to show certain percent positive AND negative
You are most welcome!
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jerid B" wrote in message ... PERFECT!!! Thanks so much! "Bernard Liengme" wrote: =IF(ABS(U260)0.08,"***","") or =IF(ABS(U260)8%,"***","") will show *** is U260 is greater than ±0.08 or 8% For 15% use =IF(ABS(U260)15%,"***","") The + sign in your formula was not required best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jerid B" wrote in message ... I have a spreadsheet and it shows in a column a percent. I want it to show me *** in the clumn next to it if it had a 15% change or more. Otherwise just left blank. I am using this formula and it's only giving me *** in the column that has a positive 15%. I want it to show the *** for a positive (increase) or negative (decrease) 15% =IF(+U2600.08,"***","") Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a column of numbers from positive to negative? | Excel Discussion (Misc queries) | |||
| Adding only the negative or positive numers in a column or row | Excel Discussion (Misc queries) | |||
| Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
Linear Mode
