| 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! |
| 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) | |||
Threaded Mode
