| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop SumProduct formula from rounding up
Thank you, you're right as usual!
"Dave Peterson" wrote: Widen the column--or change the font size. If the cell is formatted as general, then excel will try to display what it can. If you change the numberformat to Number, then if the text won't fit in the cell, you'll see ###'s. Judy L wrote: Can someone help please? I have the following formula =SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27) and it returns a value of 177 Yet on a separate summary sheet (that is linked to read the value of that cell) the correct value comes up 176.5 Is there a way to prevent this? Any help would be greatly appreciated. Thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To stop the rounding of numbers | Excel Discussion (Misc queries) | |||
| stop number rounding | New Users to Excel | |||
| How do I get my formula to stop rounding up | Excel Worksheet Functions | |||
| stop rounding | Excel Discussion (Misc queries) | |||
| Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
