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 2 customer names the column m is 9 days after the date in column J. I'm honestly only recently getting into more complex functions but any help would be appreciated. TIA
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 2 customer names the column m is 9 days after the date in column J. I'm honestly only recently getting into more complex functions but any help would be appreciated. TIA
4 Replies
- 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.
- I got #VALUE!
