Return value if cell greater then 0

D

Dave Semple

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

Duke Carey

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)
 
N

Niek Otten

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

Dave Semple

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
 
D

Dave Semple

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

Thanks again for the help.

Regards

Dave Semple
 
Top