Comparing three cells B2 thru D2 need the first value that exceeds 0 to be the value of K2. What's the formula I need?
I'm using Excel 2007 in a Windows enviroment. Comparing three cells B2 thru D2 need the first value that exceeds 0 starting with B2 then C2 then D2 to be the value of K2. What's the formula I need? Thanks
Open in new window
HTH,
Kent