How do I round a number to the nearest .49 in a cell that has
in [Functions]
|
From: Butrcup624 on 2 Jul 2008 20:25 I think both answer were the same, but worded a little differently. But it worked!!! Thank you! "T. Valko" wrote: > >E3*50%+E3 > > Is the same as: E3*1.5 > > >I need it to round up (.01 - .48) to .49 > > What if E3*1.5 = a whole number like 150? > > Maybe this: > > =CEILING(E3*1.5+0.01,0.5)-0.01 > > 0 to 0.49 rounds to 0.49 > 0.5 to 0.99 rounds to 0.99 > > -- > Biff > Microsoft Excel MVP > > > "Butrcup624" <Butrcup624(a)discussions.microsoft.com> wrote in message > news:978AF28C-B5AB-40E2-AC84-EC820DA1E8D9(a)microsoft.com... > >I am a novice, but I think this is close to what I'm trying to acheive. I > > have a column of numbers that I need to double whose sum is then added to > > itself. Then I need it to round up (.01 - .48) to .49, or (.50 to .98) to > > .99. I started with =SUMPRODUCT(E3*50%+E3) but got confused as to how I > > would > > apply the "round" function. > > >
From: T. Valko on 2 Jul 2008 22:00 >I think both answer were the same, but worded a little differently. No, they don't work the same. E3 = 20 E3*50%+E3 (or E3*1.5) = 30 One formula returns 29.99 and the other returns 30.49. -- Biff Microsoft Excel MVP "Butrcup624" <Butrcup624(a)discussions.microsoft.com> wrote in message news:8C632750-7F73-40B9-9166-92E9016B9C36(a)microsoft.com... >I think both answer were the same, but worded a little differently. But it > worked!!! Thank you! > > > "T. Valko" wrote: > >> >E3*50%+E3 >> >> Is the same as: E3*1.5 >> >> >I need it to round up (.01 - .48) to .49 >> >> What if E3*1.5 = a whole number like 150? >> >> Maybe this: >> >> =CEILING(E3*1.5+0.01,0.5)-0.01 >> >> 0 to 0.49 rounds to 0.49 >> 0.5 to 0.99 rounds to 0.99 >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Butrcup624" <Butrcup624(a)discussions.microsoft.com> wrote in message >> news:978AF28C-B5AB-40E2-AC84-EC820DA1E8D9(a)microsoft.com... >> >I am a novice, but I think this is close to what I'm trying to acheive. >> >I >> > have a column of numbers that I need to double whose sum is then added >> > to >> > itself. Then I need it to round up (.01 - .48) to .49, or (.50 to .98) >> > to >> > .99. I started with =SUMPRODUCT(E3*50%+E3) but got confused as to how I >> > would >> > apply the "round" function. >> >> >>
|
Pages: 1 Prev: Complicated comparison and highlighting question Next: If Then forumal |