Keeping cell constant when formula is from another worksheet

[twalker7]

I have a formula that needs to be applied to an entire column. It is doing a calculation with information from an other worksheet. How do I use the $ to keep the cell information from the other worksheet constant. For example, here is the formula:

=V5*0.01*Slider_work!B5+Slider_work!B2

The V5 represents the column that will change. The Slider_work!B5 and Slider_work!B2 need to remain constant. I am sure this is an easy answer but prefer to ask the experienced folks here than google for 30 min. Thank you for your help!

 

[mikerickson]

If you use the formula =V$5*0.01*Slider_work!$B$5+Slider_work!$B$2

the V5 will change as it is dragged horizontaly, the other references will not change.

 

[twalker7]

thank you!

 

[twalker7]

If you use the formula =V$5*0.01*Slider_work!$B$5+Slider_work!$B$2

the V5 will change as it is dragged horizontaly, the other references will not change.

Now, I would like to only apply the formula to cells that have something in the V column. If cell V8 does not have anything in it then I would like it left blank. It seems I could accomplish this with an IF THEN formula but what I tried did not work. Basically, I want to say:


IF V$5 is > 1 then *0.01*slider_work!$b$5+slider_work!$B$2 otherwise blank

Any ideas?

 

[mikerickson]

The IF formula sounds like the way to go, what formula did you try?