“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=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