Forum Discussion
Help with IF and absolute/relative cell references
Hello, I'm using PC/Windows 10/365 Pro Plus. I'm trying to create a formula in a column to check two conditions and if true return the first figure in a column ($D$8). But for each cell below th...
=IF(AND($B$4="Yes",[@Item]>=$B$3+3),INDEX($D$7:$D$26,COUNTIF(Table1[[#Headers],[Item]]:[@Item],">="&$B$3+3)),0)
Thank you so much. Works perfectly.