| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to return an answer using a calculation
I need a formula that if a number in a cell is greater to or equal to a
number in a seperate cell it calculates the difference. This is for over/under calculation. If the cash that is suppose to be there is greater than the actual cash counted it's a shortage, if the cash that is suppose to be there is less than the actual cash counted it is an overage. The formula need to return a negative or positive or Zero number. It can be in one or two seperate formulas. Thank you. 95 - 85 = 10 85 - 95 = -10 95 - 95 = 0 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return an answer using a calculation
Hi
=A1-B1 HTH Michael M "Autumn Dreams" wrote: I need a formula that if a number in a cell is greater to or equal to a number in a seperate cell it calculates the difference. This is for over/under calculation. If the cash that is suppose to be there is greater than the actual cash counted it's a shortage, if the cash that is suppose to be there is less than the actual cash counted it is an overage. The formula need to return a negative or positive or Zero number. It can be in one or two seperate formulas. Thank you. 95 - 85 = 10 85 - 95 = -10 95 - 95 = 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show the formula and the answer? | Excel Discussion (Misc queries) | |||
| Copying a calculations answer and not the calculation | Excel Worksheet Functions | |||
| Formula correct, answer wrong | Excel Discussion (Misc queries) | |||
| Excel Calculation Error for formula to sum | Excel Discussion (Misc queries) | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
Linear Mode
