| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The formula result is 76% but the cell shows 0%. Why?
I'm trying to show the % of billing is contributed by the top 3 ranked
accounts, so have used a formula which I've used successfully on another sheet (=SUM(IF(list of ranked data<4,billing amounts,0))/Total Billing). The cell shows 0% but when I click the fx button it gives the answer as 76% (which is correct) but it just won't show the result in the cell! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell shows formula not the result | Excel Worksheet Functions | |||
| The formula shows in cell but not the result | Excel Discussion (Misc queries) | |||
| Cell shows formula eg ='Sheet21'!F3 instead of result | Excel Worksheet Functions | |||
| Cell shows only formula, no result | Excel Worksheet Functions | |||
| Cell shows only formula, no result | Excel Worksheet Functions | |||
Threaded Mode
