Row Calculation

[CandiC]

I have three columns of information

..............A...........................B.........................C.......
Expected Amount .........Amt recd..............difference

I would like column "C" to contain the differnce of (cell B minus cell A)
but if Cell B is blank I would like the result of cell "C" to be blank until
an amount is entered into Cell "B". Can someone help?

 

[Eduardo]

Hi,
in C enter

=if(B2="","",B2-A2)

if this helps please click yes thanks