Applying Functions to Another Cell

S

ScS

If I want to use a formula on a separate cell that the
formula is not entered into, how would I go about doing
that?

ex: In Cell A1 I have =ROUNDDOWN(A1,-3)

I want to apply this to a separate cell than a1. Also, if
I only want the function to use the formula for values
that exceed 2000, how would I do that?

ScS
 
F

Frank Kabel

Hi
not quite sure nut put this formula in A1:
=IF(B1>2000,ROUNDDOWN(B1,-3),B1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Remove punctuation mark, Split cells & average accross column 4
Referencing the values of multiple cells in conditinal formatting. 0
Can UDF return a customized hyperlink? 3
Round Down 2
Show value from one cell in another cell if today falls between a date range 5
Show a cell's formula in text format in a linked cell 2

Top