calculating the difference of two values, leaving blank any blank rows.

[hunterdraygon]

I have a simple sheet, 2 figures e.g.

A B C
57 54 =
57 54 =

57 54 =

57 54 =
57 54 =

I simply want to calulate the difference, but on a large, ever changing scale.
what i need is for the whole of column C to have the calulation code, but not showing any figures or content within the blank rows.

i am using excel 2010

Any assistance is greatly appreciated.

Thank you
Alan

[sktneer]

You may try this......

Assuming the numbers are in A2 and B2 then in C2, try this

Please Login or Register  to view this content.