penalty

I need to calculate a number in a cell based on IF formula. If salary is $20,000,000 over allowed baseline - then penalty is $4.75. At each additional $5,000,000 penalty increases by factor of $.50. So in perfect world a formula to calculate these incremental values. $20,000,000 over allowed...

Hi All, Would someone be able to help me in designing a timesheet in excel, I do not know how to do the formulas for all the rules below. I guess to have seperate columns that splits the hours worked into the following categories and seperate columns for the rules? I appreciate this is a lot...

Please help me again. I want to create a formulas from which the conditional statements will be coming from 3 different columns. A1 B1 C1 D1 Encode Date Penalty Prev. issued Status wherein Columns A,B and C must...

Hi, Wonder if anyone can help? I'm trying to refine a results system for a type of motorsport event called motorkhana. A timing beam system automatically inserts the competitor's elapsed time over a "test", however officials need to manually add any penalties to the system. A separate...

Hi, This is two questions in one, but they're linked: I want to record a time duration in MM:SS into a cell. I've set the format using "custom" and "MM:SS", but to get it to display properly I have to enter zero values for the hour, e.g. 00:10:32 to display 10:32. Is there a way to avoid...