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