Excel IF Function

Riny_van_Eekelen 

I tried Gemini from Google. On any question it gives 3 variants of answer

First one

=IF(A2="yes", DATEDIF(B2, TODAY(), "D")-5, DATEDIF(B2, TODAY(), "D")-3)

Second one is more friendly but with notice

• This formula assumes that the values in cell A2 are exactly "yes" and "no" (case-sensitive). You can adjust the formula using the LOWER function to make it case-insensitive, like this:

=IF(LOWER(A2)="yes",B2-5,B2-3)

And third, not default variant is

=IF(A2="yes", B2-5, B2-3)

When I asked why LOWER() is needed, 3 reasons for that

1. Using LOWER() explicitly demonstrates your intention to perform a case-insensitive comparison.

2. While Excel is currently case-insensitive, there's always a chance that future versions might offer case-sensitive options. Using LOWER() ensures your formulas will continue to function correctly regardless of any future changes

3. Getting into the habit of using LOWER() for text comparisons can be beneficial, making your code more consistent and transferable across different situations.

People need deep knowledge of Excel to use AI answers efficiency. Or to make the decision not to use the answer since it could be simply wrong.