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.

Return value if cell greater then 0
 

It helps if you state your question clearly.

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

=if(A10,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.

Return value if cell greater then 0
 

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" wrote in message
...
for a column of numbers greater then 0 (zero) divide by .8 and return
value
to another column.

Return value if cell greater then 0
 

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" wrote in message
...
for a column of numbers greater then 0 (zero) divide by .8 and return
value
to another column.

Return value if cell greater then 0
 

In A1:

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

Fill down as far as needed

--
Kind regards,

Niek Otten

"Dave Semple" wrote in message
...
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" wrote in message
...
for a column of numbers greater then 0 (zero) divide by .8 and return
value
to another column.

Return value if cell greater then 0
 

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" wrote in message
...
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" wrote in message
...
for a column of numbers greater then 0 (zero) divide by .8 and return
value
to another column.