Thread: Row Calculation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CandiC CandiC is offline
external usenet poster
 
Posts: 37
Default 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?