Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've read most of the similar topic posts but still haven't quite figured out
what to do. I used to teach computer science so I know conditionals, I just don't know how to put it in Excel ( we're using 2007). What I have is a workbook set up for time keeping. If someone enters a P in any cell I need it to Add 1 to the AL column of that row, but if they enter a lower case p it needs to add only 0.5 to the AL column of the row. For the same cell, if the value entered was X or x, the AK column of the row is updated by those same values. Thanks for any responses! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |