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
244 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding Text that self adjusts in a Cell 8 33
Looking for macro to do version saving of workbooks in Excel 2016. 6 39
macro for each dropdown 15 46
Formula 6 47
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

867 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

13 Experts available now in Live!

Get 1:1 Help Now