I have data in some columns where if one column has a value less than 10 then i need the data in the K column. Seems like this should be simple but my following formula isnt working. I need to apply this forumla to the entire spreadsheet which is over 40000 entries long. Could someone help me with whats missing?
=IF((D9< 10),K9, " ")
Your formula seems to work fine. What exactly is it "not" doing in your spreadsheet? Do you have "Tools > Options > Calculation" set to Automatic?
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Yes calculations are set to automatic. Problem is, the formula is showing a value of 0 when it should be looking at column K and grabbing that number.
Basically i need it to check Column D and if Column D has a number LESS THAN 10, then return the value in column K if column D is greater than 10, I need it to be blank.
Click on Column D which contains value..
Go to Data , Text To column , Select Fixed widht and Click finish.
Hopefully this should work
Shijesh Kumar
http://shijesh.wordpress.com/
Thanks so much that was the problem!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks