Return value if cell greater then 0

for a column of numbers greater then 0 (zero) divide by .8 and return value
to another column.

It helps if you state your question clearly.

Assuming your value is in A1, I think you want something like this

=if(A1>0,A1/.8,something else A1<=0)


"Dave Semple" wrote:

> for a column of numbers greater then 0 (zero) divide by .8 and return value
> to another column.

I take it you didn't like my answer in the other newsgroup.

If you mean you want the formula in Column A, Check Column B and have the
answer in Column C:
not possible without programming. Formulas give a result in the cell they
are in, not anywhere else (fortunately!)
If this is not what you mean, please spend a few words explaining what
you're trying to achieve.

--
Kind regards,

Niek Otten

"Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
news:4B7A4541-8C53-478D-8D87-B007B4584BAA@microsoft.com...
> for a column of numbers greater then 0 (zero) divide by .8 and return
> value
> to another column.

No, I just didn't read your answer.......and I thought I should clarify the
question.
ok here' what I need to do.
I have a column of cost dollars (numbers) in B1 and I want to mark them up
18% and show that result in another row ie A1, but some cells in B1 are
blank. Trying to get away from copy - paste, if you know what I mean

"Niek Otten" wrote:

> I take it you didn't like my answer in the other newsgroup.
>
> If you mean you want the formula in Column A, Check Column B and have the
> answer in Column C:
> not possible without programming. Formulas give a result in the cell they
> are in, not anywhere else (fortunately!)
> If this is not what you mean, please spend a few words explaining what
> you're trying to achieve.
>
> --
> Kind regards,
>
> Niek Otten
>
> "Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
> news:4B7A4541-8C53-478D-8D87-B007B4584BAA@microsoft.com...
> > for a column of numbers greater then 0 (zero) divide by .8 and return
> > value
> > to another column.
>
>
>

In A1:

=IF(B1="","",B1*1.18)

Fill down as far as needed

--
Kind regards,

Niek Otten

"Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
news:63E01F1C-2557-4CB6-BD42-35C71BF94AEE@microsoft.com...
> No, I just didn't read your answer.......and I thought I should clarify
> the
> question.
> ok here' what I need to do.
> I have a column of cost dollars (numbers) in B1 and I want to mark them up
> 18% and show that result in another row ie A1, but some cells in B1 are
> blank. Trying to get away from copy - paste, if you know what I mean
>
> "Niek Otten" wrote:
>
>> I take it you didn't like my answer in the other newsgroup.
>>
>> If you mean you want the formula in Column A, Check Column B and have the
>> answer in Column C:
>> not possible without programming. Formulas give a result in the cell they
>> are in, not anywhere else (fortunately!)
>> If this is not what you mean, please spend a few words explaining what
>> you're trying to achieve.
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
>> news:4B7A4541-8C53-478D-8D87-B007B4584BAA@microsoft.com...
>> > for a column of numbers greater then 0 (zero) divide by .8 and return
>> > value
>> > to another column.
>>
>>
>>

Thanks Niek, works perfect. Saves a lot of time.

Thanks again for the help.

Regards

Dave Semple


> In A1:
>
> =IF(B1="","",B1*1.18)
>
> Fill down as far as needed
>
> --
> Kind regards,
>
> Niek Otten
>
> "Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
> news:63E01F1C-2557-4CB6-BD42-35C71BF94AEE@microsoft.com...
> > No, I just didn't read your answer.......and I thought I should clarify
> > the
> > question.
> > ok here' what I need to do.
> > I have a column of cost dollars (numbers) in B1 and I want to mark them up
> > 18% and show that result in another row ie A1, but some cells in B1 are
> > blank. Trying to get away from copy - paste, if you know what I mean
> >
> > "Niek Otten" wrote:
> >
> >> I take it you didn't like my answer in the other newsgroup.
> >>
> >> If you mean you want the formula in Column A, Check Column B and have the
> >> answer in Column C:
> >> not possible without programming. Formulas give a result in the cell they
> >> are in, not anywhere else (fortunately!)
> >> If this is not what you mean, please spend a few words explaining what
> >> you're trying to achieve.
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >>
> >> "Dave Semple" <DaveSemple@discussions.microsoft.com> wrote in message
> >> news:4B7A4541-8C53-478D-8D87-B007B4584BAA@microsoft.com...
> >> > for a column of numbers greater then 0 (zero) divide by .8 and return
> >> > value
> >> > to another column.
> >>
> >>
> >>
>
>
>