forumulas

Hi Please can someone look at the attached sample spreadsheet. The first sheet returns a value of 1 or 0 depending on whether the calls on the second sheet are resolved within the target time or not. If they are they get a value of 1 and if they are unresolved, or resolved outside of the...

Hi all, Firstly, as always, apologies if this has been answered several times already! I have searched and tried various answers to no avail so now seeking professional help!?!?! :rofl: Basically, all I wan't to do is change the value of one cell based on what is entered into another. To be...

Hi I am using the following formula to count the number of suppliers by post code off a coverage sheet : =COUNTIF(DetailPostCode!C:C,"All") =COUNTIF(DetailPostCode!C:C,"AB") etc The data is stored as a table so I am able to apply search parameters but when I change the parameters I need the...

i have a spreadsheet calculates the total yield of a portfolio. now i have to figure out how to add investments and have the spreadsheet calculate the new yield automatically. what functions should I use?

I am trying to create a generic time sheet for employees that work part time, full time, and over time. Employees do not clock out for lunch, so 30 minutes is deducted from the daily total. My equation for daily is =(((B9-B8)+(B11-B10)+(B13-B12)+(B15-B14)+(B17-B16)+(B19-B18))*(24-0.5))...

Hi there, First, thanks in advance for any help. I am working on an MS Excel 2010 spreadsheet that tracks attendance records. If students miss two or more days in a row, I need to follow up on it. My goal is to create a status column for each student where the cell will turn red if they miss...