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
> > wrote:
>
>>
>> Hi, I need a formula to multiply units and cents, I want to multiply
>> 26.590 cents by 253.33 units.
>>
=ROUND((A1*B1)/100,2)
try this see if it helps
On Fri, Aug 9, 2013 at 10:48 AM, John Noonan 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 of
> each uni
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 an
