Avatar of boxer327
boxer327
 asked on

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
Microsoft Excel

Avatar of undefined
Last Comment
Kent Dyer

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shanan212

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kent Dyer

Something like this should do the trick for you..

=IF(B2>0,B2,IF(C2>0,C2,IF(D2>0,D2)))

Open in new window


HTH,

Kent
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck