| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing results in cell using formulas
In my tempate I have three cells:
Cell A shows TOTAL HOURS to accomplish the job based off input from a seperate formula. Cell B shows TOTAL STRAIGHT TIME for the performance period, exmple: X(8) times Y = TOTAL STRAIGHT TIME X = amount of personnel 8 = an 8 hour day Y = the amount of working days If the amount of TOTAL HOURS < TOTAL STRAIGHT TIME then C =0 and show the change if the TOTAL HOURS TOTAL STRAIGHT TIME. Please advise. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing results in cell using formulas
In C2, use =MAX(A2-B2,0)
-- David Biddulph "Jonathan" wrote in message ... In my tempate I have three cells: Cell A shows TOTAL HOURS to accomplish the job based off input from a seperate formula. Cell B shows TOTAL STRAIGHT TIME for the performance period, exmple: X(8) times Y = TOTAL STRAIGHT TIME X = amount of personnel 8 = an 8 hour day Y = the amount of working days If the amount of TOTAL HOURS < TOTAL STRAIGHT TIME then C =0 and show the change if the TOTAL HOURS TOTAL STRAIGHT TIME. Please advise. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| printing without zeros showing in a cell with formulas | Excel Worksheet Functions | |||
| can I use 2 formulas in 1 cell and display both results | New Users to Excel | |||
| copy cell results and not underlying formulas | Excel Discussion (Misc queries) | |||
| Formulas not showing results | Excel Worksheet Functions | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
Linear Mode
