 # Get instant live expert help on I need help with excel n a to 0 “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

=IF(F20="YES","5",IF(F20="NO","0",IF(F20="N/A","0",""))).....I NEED N/A NOT TO TAKE AWAY FROM TOTAL VALUE
Solved by B. F. in 26 mins
I'm trying to get a similar function to work on my excel. =ARRAY_CONSTRAIN(ARRAYFORMULA(index('Contract Month Detail'!\$E:\$E,match(C6,'Contract Month Detail'!\$N:\$N,0))), 1, 1)
Solved by S. L. in 28 mins
Hi, I need a formula to work out how many values are less than a certain time value, simple "countif" do not work as it is a filtered spreadsheet. Here's the formula that I have got so far: SUMPRODUCT(SUBTOTAL(3,OFFSET(Current_Month!N\$2:N\$10000,ROW(Current_Month!N\$2:N\$10000)-MIN(ROW(Current_Month!N\$2:N\$10000)),,1)),--(Current_Month!N\$2:N\$10000>"24:0:0")
Solved by K. L. in 26 mins
I need a formula that creates a win / loss / draw situation according to these rules: n > 10 = WIN n < 0 = LOSS 0 < n < 10 = DRAW whatever I try it doesnt seem to work. It either ignores the draw rule or makes everything a draw
Solved by O. F. in 20 mins
I need a formula to say IF Column A length > 0 AND Column Q length = 0 THEN Column I = "N"
Solved by S. H. in 14 mins