From C4:C100 i have a range of dates related to a range of numbers N4:N100. After puttin a specific date in G4 the formula must verify if N related values is bellow 100 then it shall be counted as "1" otherwise blank.
Example:
C4=10/02/2019 N4=554
C5=11/02/2019 N5=136
C6=12/02/2019 N6=4
C7=13/02/2019 N7=123
C8=14/02/2019 N8=90
C9=15/02/2019 N9=76
C10=16/02/2019 N10=151
G4=15/02/2019 H4=1
Bookmarks