Forum Discussion
Ifs
Hello, I am trying to set up a spreadsheet where if the text value in column A is either of 2 customer names then the date in column M is 3 days after the date in column J and if it is not one of the...
Thank you for that formula. How would I make it for the whole column a and the whole column m
Depends on which version of Excel you are. If on one which supports dynamic arrays that could be
=J:J+3 + IF(OR(A:A="customer1",A:A="customer2"),6,0)If not, drag formula down. In both case it's better to use Excel Tables or at least dynamic ranges.