-
Curtis, Thanks for the formula... Put it in and it seems to work somewhat...a value is being returned. There is a problem, though...maybe I am doing something wrong.... What it is doing is that no matter what cell number I put in for A or B, the value returned is always Z1. Any thoughts what's going...
-
I am trying to merge two datasets, and it seems what I am trying to do should be something quite simple, but I am having a brain cramp on how to do it...so, someone, please help.... Here's what I am trying to do: For illustration purposes, let's use Columns A, B, C, X, Y, and Z. I want to write...
-
To whom may be able to assist. I am currently working on defining a function/automated process for generating sample intervals from a data set of intervals created from a drill hole. The data that has been captured is the 'rock type' and can stretch over 0.1-10's of metres. When sampling...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
Please any1 evaluate and let me know where i am going wrong. All cells produce an OUtcome of J regardless of the amounts being evaluated. Using Excel 2007 =IF(F18<3579,"A",IF(F18<4349,"B",IF(F18<5299,"C",IF(F18<6089,"D",IF(F18<6969,"E"...
-
I'm hoping you can help me with a formula. I have a workbook that has 3 tabs. The first is the main log, the second I want to extract certain information on a line that's tied to 2 criteria (product name and tract number) and the third I want to have extract based on 3 criteria (product name...
-
Dear forum users, I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product. We have pre-defined max coverage and min coverage. On this picture you can see in red the max, in blue the min and in green the actual (projected) coverage. http://docs...
-
Hi All, I need help in terms of usage of which funtion formula to do the following. I have an excel sheet in which i would like to use the ' IF' funtion and then by formatting arrive at the values in the cell, say if the value of a particular cell is > 3 then the cell in which we are putting...