Hi, I need a formula to multiply units and cents, I want to multiply
26.590 cents by 253.33 units.
The units are kWh units (253.33) and the cents (26.590) are the cost of
each unit.
Example:
A1 contains 253.33
B1 contains 26.590
D1 would contain the rounded dollar to the correct
=ROUND((A1*B1)/100,2)
try this see if it helps
On Fri, Aug 9, 2013 at 10:48 AM, John Noonan terr...@adam.com.au wrote:
Hi, I need a formula to multiply units and cents, I want to multiply
26.590 cents by 253.33 units.
The units are kWh units (253.33) and the cents (26.590) are the cost
On Friday, August 9, 2013 2:57:31 PM UTC+9:30, ashish wrote:
=ROUND((A1*B1)/100,2)
try this see if it helps
On Fri, Aug 9, 2013 at 10:48 AM, John Noonan ter...@adam.com.aujavascript:
wrote:
Hi, I need a formula to multiply units and cents, I want to multiply
26.590 cents by