Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nested formula alternative
I must be sleepy because I can't think of a better alternative to this. I'm
using nested IF's to get the last entry in a row, and moving the column header (percent completed) to the end of the row. This seems clunky, plus some sheets have 10% increments and the formula nesting is limited to 7. Any ideas? 25% 50% 75% 100% Pct Complete Alpha 10/12/07 25% Bravo 10/12/07 10/14/07 50% Charlie 10/13/07 10/19/07 75% Delta 10/15/07 50% This is the formula down column F. =IF(E2<"",$E$1,IF(D2<"",$D$1,IF(C2<"",$C$1,IF(B 2<"",$B$1,"")))) TIA Charlie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative formula for getting totals | Excel Worksheet Functions | |||
What is an alternative to nested IF statements? | New Users to Excel | |||
Nested IF fn Alternative | Excel Discussion (Misc queries) | |||
too many arguments in formula. alternative? | Excel Discussion (Misc queries) | |||
Nested Vlookup or alternative? | Excel Worksheet Functions |