Get instant live expert help on I need help with excel f2 not working
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
This formula is not working: = (11.5*D2) + (7.55*E2) + (12.5*F2) 4016
Solved by A. H. in 24 mins
=IF(AND(F2>=2,F2<=15),"2",IF(AND(F2>=16,F2<=25),"3",IF(AND(F2>=26,F2<=90),"5",IF(AND(F2>=91,F2<=150),"8",IF(AND(F2>=151,F2<=500),"13",IF(AND(F2>=501,F2<=1200)"20","IDK")))))) I am not sure why Excel wont accept this compound IF statement... help...
Solved by I. J. in 25 mins
I am having an issue with an excel formula not returning the expected results. =IF($F2<>"",IF(YEAR(Y$1)&MONTH(Y$1)<=YEAR($F2)&MONTH($F2),$T2,IF(YEAR(Y$1)&MONTH(Y$1)>YEAR($F2)&MONTH($F2),0)),$T2)
Solved by C. D. in 21 mins
I am working on switch statements in excel.i a writing formula for a column which contains decimal values from 30 to 100. My formula is Switch(F2,"or(F2>30,F2<=36)",..........),the problem here is that this(OR(F2>30,F2<=36)) is not working.What should i do if i want to use limits(For example : 30 to 36,36-50,etc) in switch case statements.
Solved by K. H. in 25 mins
I need help fixing this formula. I need to add some to the string, but it isn't working. I need it to be Enterprise!E:E,F2, but I can't get it to work =IF(AND(COUNTIF(Enterprise!F:F,F2)=0,COUNTIF(Enterprise!G:G,F2)=0),F2,"")
Solved by B. H. in 21 mins