IF Functions

[Pippy79]

HI All,

i need to do a IF formula as shown below. formula is needed in column C as per the description.

	A	B	C
1​	Date		Date+1
2​	13/12/2023​	A	If b2 = "A" then Display A2 +1 day
3​	14/12/2023​	A
4​	15/12/2023​	B	If b4 = "B" then Display "N/A"
5​	16/12/2023​	B
6​	17/12/2023​	A
7​	18/12/2023​	A

can you advise?

thanks

 

[RoryA]

I think you mean:

=IF(B2="A",A2+1,"N/A")

That assumes that column B is always either A or B.

 

[Pippy79]

what if column B can be multiple text options? there are always only 2 outcomes (+1 or N/A)

 

[Peter_SSs]

For your sample data (or a new slightly larger/more varied set), can you manually fill in all the expected results and post that again with any further explanation to help clarify?

 

[RoryA]

Maybe:

=IF(B2="A",A2+1,IF(B2="B","N/A",""))

 

[Pippy79]

Thanks RoryA this works.