| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage
I wish to make a comparision between one month percentage to another and show
the difference to state whether it is higher or lower. Is there a formula that could do this. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200606/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage
If the percentages are in Cell A1 and A2
use the folliwing formula : =if(A2A1,"Higher";IF(A2<A1,"Lower","Equal") "chedd via OfficeKB.com" wrote: I wish to make a comparision between one month percentage to another and show the difference to state whether it is higher or lower. Is there a formula that could do this. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200606/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage
If you have a list of percentages in column A, then this in B1, copied down,
will provide a graphical sort of visual....... =REPT("*",A1*100) Vaya con Dios, Chuck, CABGx3 "chedd via OfficeKB.com" wrote: I wish to make a comparision between one month percentage to another and show the difference to state whether it is higher or lower. Is there a formula that could do this. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200606/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
| Percentage Calculation | Excel Worksheet Functions | |||
| Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
| display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
