Forum Discussion

kimbera68's avatar
kimbera68
Copper Contributor
May 24, 2022

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...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
May 24, 2022

Hi kimbera68 . Alternatively:

=IF(AND(B$4="yes", [@Item]>=B$3+3),
    OFFSET(D$8,COUNT(B$7:B7),0),
    "-"
)

 

Resources