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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to round in the middle of a formula
"Simon" wrote:
=(D11*E11)+(((D11-39.45)/2+39.45)*F11)+(((D11+2)/2)*G11)+(((D11/2)*H11)) [....] I've rounded them individually in other cells [....] But since they aren't rounding in the middle of the first formula, my totals aren't matching with the second set of numbers. Making assumptions about what subexpressions are rounded "individually in other cells": =round(D11*E11,2) + round(((D11-39.45)/2+39.45)*F11,2)+ round(((D11+2)/2)*G11,2) + round(((D11/2)*H11),2) ----- original message ----- "Simon" wrote in message ... 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 |
Reply |
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) |