[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
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
Medium Priority
?
282 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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

825 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