Ifs

%3CLINGO-SUB%20id%3D%22lingo-sub-2087697%22%20slang%3D%22en-US%22%3EIfs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087697%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3EI%20am%20trying%20to%20set%20up%20a%20spreadsheet%20where%20if%20the%20text%20value%20in%20column%20A%20is%20either%20of%202%20customer%20names%20then%20the%20date%20in%20column%20M%20is%203%20days%20after%20the%20date%20in%20column%20J%20and%20if%20it%20is%20not%20one%20of%20the%202%20customer%20names%20the%20column%20m%20is%209%20days%20after%20the%20date%20in%20column%20J.%20I'm%20honestly%20only%20recently%20getting%20into%20more%20complex%20functions%20but%20any%20help%20would%20be%20appreciated.%20TIA%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2087697%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2088306%22%20slang%3D%22en-US%22%3ERe%3A%20Ifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088306%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F939332%22%20target%3D%22_blank%22%3E%40Mndsosa6741%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20M1%20it%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DJ1%2B3%20%2B%20IF(OR(A1%3D%22customer1%22%2CA1%3D%22customer2%22)%2C6%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor
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
4 Replies

@Mndsosa6741 

In M1 it could be like

=J1+3 + IF(OR(A1="customer1",A1="customer2"),6,0)
I got #VALUE!
Thank you for that formula. How would I make it for the whole column a and the whole column m

@Mndsosa6741 

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.