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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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