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.

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.