formula error

6 Topics

formula value error pls help
I M EXTENDING THE FORMULA FOR MULTIPLE VALUES ITS SHOWING VALUE ERROR , PLEASE HELP ME REGARDING THIS, EXTENDED FORMULA IS MARKED GREEN. I HAVE MULTIPLE 4 CONDITIONS THATS WHY I M EXTENDING THE FORMULA the formula is to be applied in cell E6 ,FILE ATTACHED =IF(AND(B5-C5>=-200,B5-C5<=-1),B5-C5,IF(B5-C5=-750,-150,"")+IF(B5-C5=-650,-50,""))
aayushman_mishra
Aug 18, 2019 Place Excel
1.3KViews
0likes
4Comments
PLEASE HELP... CELL REF IN MEDIAN FORMULA
Hi - is it possible to use a cell reference as a number in the Cell:Cell format. So =MEDIAN(B2:B4740) - if Cell N1 has 4740 in it - is there some way to write =MEDIAN(B2:B&'N1') so that it adds the value of a cell to equal the 2nd cell range. Hope this makes sense - it would be an amazing help if I can solve. I have added a picture of what I am referencing. Thanks you in advance!!!
Solved
PETEMAGS
Mar 29, 2019 Place Excel
4.5KViews
0likes
15Comments
Help with Cash-flow schedule
Hello, I am building a worksheet in which using contract details, I can have a calendar that displays each day's deposits. I need help with my formula that is not displaying the result requested. To best describe my issue, here is a picture of my worksheet: The columns from B to F are input column where I write the information of the contract. The column H to J are calculated using basic formulas. There seems to be 1 main issue with my formula. For the first month, from cell M3 until M35, the result is correct but from M36 on, it doesn't display any of the contract planned deposits. any idea what is wrong and how to fix it? I have attached my excel file as a reference. Your help is greatly appreciated. here is the solution: https://www.excelforum.com/excel-formulas-and-functions/1263565-cash-flow-planning-per-day.html#post5061110
yossivan
Feb 14, 2019 Place Excel
2.2KViews
0likes
3Comments
Formula
Hi All, I'm trying to develop a formula in Excell that in cell I21, will look at cell G21 and if <5 return a blank cell in cell I21, But if it has a value >5 calculates (I20-G21). Any help will be great, Thanks
Solved
jmickey15
Sep 02, 2018 Place Excel
1.9KViews
0likes
2Comments
Need Support with Index Match and If Function
Hello All, I have written a formula with a combination of If and Index functions. Below is the logic and I am able to get the required results. But I need to add one more condition I,e.. this function should work based on company code in column "B" I have 3 different values in Column "B" and each value the calendar would change. I am unable add condition =If(B2="289C" and so on. Need help =IF(X2="D",(IF(AND(Z2="Z999",Y2="Ready For Payment"),INDEX(Calendar!E:E,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)), Calendar!E:E,-1)),(IF(AND(AB2="Wkly",Y2="Ready For Payment"),INDEX(Calendar!E:E,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)), Calendar!E:E,-1)),(IF(AND(U2="MP",Y2="Ready For Payment"),INDEX(Calendar!C:C,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)),Calendar!C:C,-1)),(IF(AND(U2<>"MP",Y2="Ready For Payment"),INDEX(Calendar!E:E,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)),Calendar!E:E,-1)),"")))))))),(IF(X2="F",(IF(AND(Z2="Z999",Y2="Ready For Payment"),INDEX(Calendar!F:F,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)), Calendar!F:F,-1)),(IF(AND(AB2="Wkly",Y2="Ready For Payment"),INDEX(Calendar!F:F,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)), Calendar!F:F,-1)),(IF(AND(U2="MP",Y2="Ready For Payment"),INDEX(Calendar!D:D,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)),Calendar!D:D,-1)),(IF(AND(U2<>"MP",Y2="Ready For Payment"),INDEX(Calendar!F:F,MATCH((IF(N2<TODAY(),TODAY()+1,N2+1)),Calendar!F:F,-1)),"")))))))),"")))
Solved
Chandrakanth K
Aug 16, 2018 Place Excel
1.3KViews
0likes
3Comments
Contar.SI.Conjunto
Buenas tardes, Tengo un problema que espero que puedan resolver. Necesito extraer información de un tabla sobre una relación que he establecido para un estudio en un máster. La relación que les presento es entre bebidas y ocasiones donde se consumen. Tengo cinco variables en bebidas, agrupando en "otros" las que no se recogen en las anteriores variables, y siete variables en ocasiones. Con la fórmula CONTAR.SI.CONJUNTO he extraído todas las relaciones posibles, pero no sé cómo escribir la fórmula para que me saque los datos que cumplen la relación y no me dé 0 al no haber ninguna bebida con la palabra "otros". Las relaciones que tendría que revisar en esta muestra de mi proyecto están en color rojo, aunque las aplicaría al resto de relaciones que cuenten con "otros" en la columna bebida. Muchas gracias por su atención, Daniel Barrera
Daniel Barrera
Jul 25, 2018 Place Excel
926Views
0likes
0Comments