| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm looking to add cells (that are formated in %) in them.
a1 has 10%
a2 has 30% a3 has 10% a4 has 20% a5 has 5% a6 has 15% a7 has 10% a8 needs to be ONLY "100%" total the above percentages or default to red in color if below 100% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't Want to Print Formated Blanked Out Cells | Excel Discussion (Misc queries) | |||
| CONCATENATE Cells Formated as fractions | Excel Worksheet Functions | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
| hh:mm - mm formated 2 round to .25, .50, .75 & 1 | Excel Worksheet Functions | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Threaded Mode
