Prev: adding figures that match 2 true and 1 false if statement cond
Next: Circular Reference Warning ???
From: arKwelder on 24 Mar 2010 14:01
need to mark up 16800 items by 15% column e is my net and need column f
with new prices
From: Eduardo on 24 Mar 2010 14:14
Hi,
in column F enter

=E2*1.15

copy formula down

you can have a cell where you enter the markup % like A1, then have F
calculate it using

=E2*(1+A1)

in A1 you will enter 15

"arKwelder" wrote:

> need to mark up 16800 items by 15% column e is my net and need column f
> with new prices
From: Eduardo on 24 Mar 2010 14:21
opps you will enter 0.15 instead of 15


"Eduardo" wrote:

> Hi,
> in column F enter
>
> =E2*1.15
>
> copy formula down
>
> you can have a cell where you enter the markup % like A1, then have F
> calculate it using
>
> =E2*(1+A1)
>
> in A1 you will enter 15
>
> "arKwelder" wrote:
>
> > need to mark up 16800 items by 15% column e is my net and need column f
> > with new prices
From: "David Biddulph" groups [at] on 24 Mar 2010 16:51
.... and you may want =E2*(1+A$1) instead of =E2*(1+A1), if you are going to
copy down.
--
David Biddulph


"Eduardo" <Eduardo(a)discussions.microsoft.com> wrote in message
news:204BE07F-ED83-4445-8174-66C5CAB55EA3(a)microsoft.com...
> opps you will enter 0.15 instead of 15
>
>
> "Eduardo" wrote:
>
>> Hi,
>> in column F enter
>>
>> =E2*1.15
>>
>> copy formula down
>>
>> you can have a cell where you enter the markup % like A1, then have F
>> calculate it using
>>
>> =E2*(1+A1)
>>
>> in A1 you will enter 15
>>
>> "arKwelder" wrote:
>>
>> > need to mark up 16800 items by 15% column e is my net and need column
>> > f
>> > with new prices


 | 
Pages: 1
Prev: adding figures that match 2 true and 1 false if statement cond
Next: Circular Reference Warning ???