"Blank" cells

[Kepler]

Hi,

I've got a table in Excel where I want to do this: suppose we're in
line E; I want to fill all the cells, from E2 to E10, for example, with
blank values if E11 < 0; all the referred cells - E2 to E10 - contain
formulas.

Can I do this?

Kind regards,

Kepler

 

[Gord Dibben]

Not being able to see the existing formulas in E2:E10 kinda makes it hard to
give an answer, but how about.......

In E2 enter =IF($E$11<0,"",yourformula)

Drag/copy down to E10

Note: the cells will look blank, but won't be "null"


Gord Dibben Excel MVP

 

[RagDyeR]

Try this in E2:

=IF($E$11<0,"",EXISTING FORMULA)

And copy down to E10
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi,

I've got a table in Excel where I want to do this: suppose we're in
line E; I want to fill all the cells, from E2 to E10, for example, with
blank values if E11 < 0; all the referred cells - E2 to E10 - contain
formulas.

Can I do this?

Kind regards,

Kepler

 

[Guest]

I have read your post refering to Kepler's problem, sounds similar to
something that I would like to achieve.

If I had a table in excel with three columns, A, B ,C and I wanted c to
equal A+B.

I am obviously able to type into c, =A2+b2

I can then drag this down into the rows below.

Is there a way that I can apply this formular to ALL of the subsequent C's ?

Hope thsi makes sense

Please provide any help you can

Much appreciated

Dan

 

[Gord Dibben]

Dan

"ALL" subsequent C's means what? The entire column C?

Put your formula in C2 then copy it.

Select C3 and SHIFT + END + Down Arrow then ENTER ksy.

Alternative.............

Copy C2 then in the name box enter C3:C65536 and ENTER>ENTER


Gord

 

[Guest]

Thankyou for your help, worked a treat!