Hello
I need some help with a picking out data for "column S"
if values in "column I" "column J" "column K" is greater then 1.3 then return the value in column S2
so for cell S3 if I3,J3,K3>1.3 return value S$2$, if not then return value 0
as the sheet attached.
thank you
Veer
Hi -
How about IF(AND(I3>1.3, J3>1.3,K3>1.3),$S$2,0)
This formula will always return what is in S2 wherever you copy it to. So if you copy this down to row 4, and I4,J4,and K4 are >1.3, you will still get whatever is in S2. Is that OK?
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Hello
I have just tried this but it give me the 0 value.
thank you
Veer
Hm. Seems to work for me. Attached is a spreadsheet with sample data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks