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.
>
>
>