Excell question

[shuckthecorn]

Im creating a very simple timecard program for employees. In the overtime box I want it to simply calculate overtime if the employee worked more than 8 hours. But as it stands now if employee works 5 hours the overtime box reads -3. Can I create a formula that will only calculate if the result is a positive number?

Shuck

[bailey]

yes you can, but I can't tell you what it is.

[foolishone]

=IF([hours > 8],"[overtime hours]*[overtime hourly wage]","[put false result here]")

Go to Insert > Function > Logical > If

Type in a condition that has to be met. In my example, hours has to be > 8 (could be G13 > 8, or whatever.)

Then put in what you want to happen if it is met, or if the condition is true. In my example you take the overtime hours and multiply by the hourly wage. Could be G8 * 8.25, or whatever, if G8 held the number of hours in overtime.

Then put in what you want to happen if it isn't met, or if the condition is false. In my example I didn't put one, you could just put a hyphen so that when you scan down the column you can tell that they didn't work overtime, or you can put "none", or whatever your heart desires.

»fo

[shuckthecorn]

Thanks a ton!