Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to round in the middle of a formula
Hi there,
Can somebody help me to round in the middle of a formula. My formula is... =(D11*E11)+(((D11-39.45)/2+39.45)*F11)+(((D11+2)/2)*G11)+(((D11/2)*H11)) The problem is I need the last three groups rounded individually I've rounded them individually in other cells with =ROUND(((M10-39.45)/2)+39.45,2) But since they aren't rounding in the middle of the first formula, my totals aren't matching with the second set of numbers. I hope this is clear enough |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help with transferring middle part of a cell entry | Excel Discussion (Misc queries) | |||
Round up-down-or middle | Excel Discussion (Misc queries) | |||
Can you put a formula in the middle of text? | Excel Discussion (Misc queries) | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) |