Forum Discussion
VERY NEW to EXCEL
- Thank you very much, your help is greatly appreciated.
I will let you know how it turns out.
Dale
You just have to change the cell references according to where the data is located in your spreadsheet. Your screenshot does not include row/column labels, but assuming the upper left corner is cell A1, then the formula for UPH in cell H5 would be:
=G5/SUMIF(C5:F5,">0",C$3:F$3)
For the hours in Row 3, you may just want to key in the number of hours instead of computing them in order to exclude the half hour that I assume is lunch.
I will let you know how it turns out.
Dale
- JMB17
Have a question, can I use a IF statement to change the color of a cell?
So, say my Expectation's for my UPH was 25 so that cell would turn green and if lower than 25 turn red.
I have been reading about the IF statement but not sure how to use it to change the color of a cell.
Thanks
DaleLook at using conditional formatting. Click on the home tab, conditional formatting split button in the styles group, and select new rule. This will bring up a dialog box. Then, select "format only cells that contain and fill in your criteria and select your formatting:
There is also an option to "use a formula to determine which cells to format" for more complex/custom criteria - that may be to what your reference material is referring.