| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percent of a fixed and variable number
here is my problem, I have three cells a1,b1,c1. a1: fixed, b1: variable, c1:
total of both as a %. I need to find the total precent the B1 maybe either (+) or a (-) number. if over 100% to indicate it as "100%", if between 100% and 0% to indicate it as is, and if under 0% to indicate it as a "0%". I am not even sure if its possibe. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting variable length data - outputting fixed character result | Excel Discussion (Misc queries) | |||
| Fixed column- Variable row # | Excel Discussion (Misc queries) | |||
| Variable column to fixed array | Excel Worksheet Functions | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Threaded Mode
