Row Calculation
 

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?

Row Calculation
 

Hi,
in C enter

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

if this helps please click yes thanks

"CandiC" wrote:

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?