| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
| How to do the calculation - 29 Nov? | Excel Discussion (Misc queries) | |||
| Calculation | New Users to Excel | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Hybrid Mode
