| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop SumProduct formula from rounding up
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 |
| 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) | |||
Threaded Mode
