Help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when working with decimals the below formula works, but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))
 
i would like to be able to calculate E5:j5 to answer in
the following way>
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05
 
I'm really sorry, but when I add these numbers up I get 36.05 whichever way I do it. I just don't understand what you are trying to do.
 
=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))
..3 + .15 + .3 + .3 = 1.45
this formula enables me to use it for a time calculation.
But it only works when i have decimals no whole number in
the cell. i was wonder what im missing to be able to get
it to work if the decimal that has a whole number with it.


-----Original Message-----
I'm really sorry, but when I add these numbers up I get
Click to expand...
36.05 whichever way I do it. I just don't understand what
you are trying to do.
 
i would like to be able to calculate E5:j5 to answer in
the following way>
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05
Click to expand...

The **array** formula:

=INT(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60))+
MOD(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),1)*0.6

To enter an **array** formula, you need to hold down <ctrl><shift> while
hitting <enter>. XL will place braces {...} around the formula.

If you have the analysis tool pak installed, an alternative **array** formula
is:

=DOLLARFR(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),60)


--ron
 
Thank you
-----Original Message-----


The **array** formula:

=INT(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60))+
MOD(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),1)*0.6

To enter an **array** formula, you need to hold down
Click to expand...
 
Back
Top