Showing related tags and posts accross the entire site.
-
Wow, that's some code! I doubt anyone is going to look at all that and try and decipher it but VBA has an If...ElseIf...End If structure for multiple levels, it is simply If This Then Do This ElseIf This Then Do This ElseIf This Then Do This Else Do This EndIf I am wondering though, if you are querying...
-
Felix I hope I have understood. (My testing had your Product ID (lookup value) in A1 and the Sampling Point Table in A4:C50 on the same sheet. (Just change these to suit)) I came up with this, which tests first if the Product ID exists at all using the AND function and ISERROR, if that returns TRUE I...
-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
Mocean I am slightly struggling to see what you are doing but maybe your issue is that the 125% is actually stored in Excel as 1.25, so you original function in any case would need to be =IF(E11<1,0). It appears you are saying that if you don't reach your quota then you get nothing, whereas if...
-
=IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...
-
IF formulas seem very popular at the minute. If you pan down one message there is one virtually identical, anyhow... =IF(A1=<30,"1-30",IF(A1=<61,"31-60",IF(A1<91,"61-90","Out of range")))
-
How about nested IFs? =IF(A1=26.75,75,IF(A1=20,45,IF(A1=18,40,IF(A1=17.5,40,"Invalid"))))