Showing related tags and posts accross the entire site.
-
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...
-
Hi All: Looking for some help on this: Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE! Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges): =IF(AT1<3499...
-
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<...
-
I have this IF - THEN question. Is it possible to write an IF statement that would take information and add it to the first blank space in a column? For instance: IF there is an "X" in A5, take the information in B5 and put it in the first blank cell in column A in Worksheet 2, then have that...