Formula ? to get an average

[zone709]

=(+B115+C115)/E115

this is returning 0.01 when it should be $78.81. What am I missing on this formula. I am adding 2 total hours divided by the Total $ amount?


Thanks

 

[husoi]

Zone,

why don't you use AVERAGE() formula? in my opinion would make more sense. I tried your formula and works as long you add the correct values. You don't need the plus sign before B115 and if the average is only 2 numbers you can replace E115 buy 2
=(B115+C115)/2
AVERAGE(B115,C115,...)

 

[zone709]

ok but E115 is total amount like $73,980 divided into B115 + C115

 

[Tetra201]

To get $78.81, you need to divide $73,980 by something, not the other way around.

So, I guess the formula should be =E115/(+B115+C115)

 

[zone709]

ok maybe I have it backwards ill try this thanks

 

[zone709]

Still returning wrong amount. Cant figure out why.

Example:
Adding B289 AND C289 Divided into $91,26508 E289

Excel 2016 (Windows) 32 bit

	B​	C​	D​	E​
289​	704​	172.5​	0​	$ 91,265.08 ​

Sheet: Trade Templete

<strike></strike>

 

[Tetra201]

Still returning wrong amount. Cant figure out why.

Example:
Adding B289 AND C289 Divided into $91,26508 E289

Excel 2016 (Windows) 32 bit

	B​	C​	D​	E​
289​	704​	172.5​	0​	$ 91,265.08 ​

<tbody>
</tbody>

Sheet: Trade Templete

<tbody>
</tbody>

<strike></strike>

What's your expected result?
=E289/(B289+C289) returns $104.12

 

[zone709]

its good thanks this is working now. Thanks everyone for the help

 

[Tetra201]

You are welcome. Glad you got what you needed.