@scaffdog,
You've missed out column C. Also note that this formula will not work in XL 2003. Too many nested IFs. In general, nested IFs with such a regular pattern can normally be replaced by a lookup or index formula. The "every other row" layout makes it a bit tricky, but doable.
cheers
teylyn
Thanks for the note on there being too many IFs for '03. I've become so used to using the newer version that I oftern forget the older versions limitations. i would not have been able to figure out the formula with the use of INDEX due to the alternate lines.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks