Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to subtract .50 from a cell if it is over 6.00
Here is the formula it works but I need it to also subtract .50 from I5 if I5
is greater then 6.00 after it is divided by 24 at the end, it is for a time sheet to take out .30 min for lunch. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract one cell from each cell in a range and count instances | Excel Worksheet Functions | |||
trying to subtract a range from a cell | Excel Worksheet Functions | |||
why cant i subtract one cell from another? | Excel Worksheet Functions | |||
subtract from numeric cell when alpha cell is occupied | Excel Worksheet Functions | |||
Subtract text in one cell from another? | Excel Worksheet Functions |