Divide with insert Value Condition.

[admirable]

Hello Experts,
I am having a Trouble using Divide two cells...

Suppose:
=C1/A1 (Formula is in B1 Cell)
but in a condition, whenever I put values in C1 & A1 then formula should apply automatically,
then Continue with C2/A2 ......... infinite...

Please suggest me a condition to apply it... I have tested this [=if(C1>1,C1/A1)] but it has a problem, When cells C1 & A1 are empty it shows False instead of Blank.

So need help here..

[FDibbins]

Hi and welcome to the forum

Im not sure I understand what you mean by...

Continue with C2/A2 ......... infinite...

do you want that same formula in B2, B3, B4 etc?

[Tony Valko]

Maybe this...

=IF(COUNT(C1,A1)<2,"",C1/A1)

Copy down as needed.

[admirable]

Hi and welcome to the forum

Im not sure I understand what you mean by...


do you want that same formula in B2, B3, B4 etc?

Yup I mean that..
And I may put B1 to B200000, but if C1 and A1 are blank then B1 must be Blank too, and when I enter Value in C1 and A1 then B1 should show divided value.

[admirable]

Maybe this...

=IF(COUNT(C1,A1)<2,"",C1/A1)

Copy down as needed.

Thank You Very Much Buddy!
That's Work and What I need...

[Tony Valko]

You're welcome. Thanks for the feedback!