• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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
0
boxer327
Asked:
boxer327
1 Solution
 
Shanan212Commented:
=IF(B2>0,B2,IF(C2>0,C2,D2))
0
 
Kent DyerIT Security Analyst SeniorCommented:
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
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now