Forum Discussion
GerdS55
Sep 23, 2023Copper Contributor
Dynamic IF AND statement
Hi, I am not sure if this is even possible to do, but here goes. The spreadsheet has stock prices over a time period. There are dozens of rows of stocks that I will need to copy this same set of f...
- Sep 23, 2023
=IF(AND(OFFSET(E11,0,0,1,$D$4)>OFFSET(E11,0,1,1,$D$4)),1,"")
HansVogelaar
Sep 23, 2023MVP
=IF(AND(OFFSET(E11,0,0,1,$D$4)>OFFSET(E11,0,1,1,$D$4)),1,"")
- GerdS55Sep 23, 2023Copper ContributorThank you very much. This works perfectly for what I am trying to do.