-
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"...
-
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...
-
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")))