-
Dan It depends how many IF's you have but basically you can nest up to seven in versions before 2007 after that is a much large number but if I use much more than two or three I tend to look to set up a table and use a VLOOKUP. The theory is.. =IF(A1="This Word",B1+C1,D1+E1) In this case...
-
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"))))