Solved

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?

Posted on 2013-01-04
2
249 Views
Last Modified: 2013-01-04
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
Comment
Question by:boxer327
2 Comments
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 38744586
=IF(B2>0,B2,IF(C2>0,C2,D2))
0
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 38744590
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now