Hi Mike
Thank you for the welcome!
I'm not sure whether or not this can be done in Excel but I'm trying to build a credit scorecard taking the log of the good:bad odds - this I've achieved already but the next step (achieving the information value) has me stumped, I'm afraid.