| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I replace a negative number at the end of a formula with a.
I have a formula in excel that calculates overtime hours for my employees.
Hours are deducted from overtime for personal time and comp time. If the personal and comp time hours are more than the overtime hours it gives me a negative number and then because it is a negative number it adds hours to the regular hours pay. I need to have the formula treat a negative number like a zero or equal a zero and not a negative amount. Here is the formula I use. =IF(G45<212,0,G45-212)*1-(E67+C67+E51) Thanks for any help you can give. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Formatting in the formula bar | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Threaded Mode
