excess

Hi All, currently I have problem to solve this issue regarding setting up formula for case below. As you can see, I have a payment threshold of $1500, while the original data that I have is only the column #number & #payment made. I want to have a formula that can generate the value in column...

Hello, I have a formula that would output me text = "Excess" if a given range of cells are empty. However I would like to add a second condition to the existing formula. Condition being if the cells have also blank space or spaces in them then output text = "Excess" aswell. for instance the...

Hello, The header is the advance filter, where I can select part number from the drop down, and below that is the data with part numbers and the remarks column showing excess and nil stock. When I select the part number in the header from the drop down, I want the NIL STOCK part numbers to...

Hi im having difficulties in calcuting this Daily Time Attendance below is the sample of what im trying to do. I am using the fomula of =MOD(TEXT(E8,"00\:00")-TEXT(D8,"00\:00"),1) in Hours Render and it give the right the answer; however there's a problem in calculating the deficit time using...