Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula question
=IF(C6:F10,G6:G7 = "V"or"PH"or"COV" than subtract 1 for each entry, then sum
total and subtract from A6 leaving remaining) I'm trying to add a formula in Excel that will subtract vacation, personal holidays or carryover vacation days from a calendar in Excel. I'm sure it's a nested formula with array's but I'm unclear as to how I should write it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |