Formula issues if and

I’m trying to write an if and formula that considers 5 different cell values for my yes / no output. I have three of them handled, but am hung up on two of the others. My current formula says “=if(an...

Excel

Formulas and Functions

mtarler
Oct 20, 2023
=if(and(N2=“real”, o2=“conditional”, CP2=“”,NOT(ISBLANK(Y2)),R2>TODAY()-16,R2<TODAY()+16),”YES”,”NO”)
or alternative options using * instead of AND and <>"" instead of NOT(ISBLANK()) and ABS()< instead of comparing each:
=if( (N2=“real”)*(o2=“conditional”)*(CP2=“”)*(Y2<>"")*(ABS(R2-TODAY())<16),”YES”,”NO”)

JenAllen932

Copper Contributor

Oct 20, 2023

I must be entering it in wrong. I receive an error when I try either of those. The top one just outputs an error and the bottom gives me the something is wrong with the formula pop up and doesn’t give an output.

mtarler

Silver Contributor

Oct 20, 2023

my apologies, in each case TODAY must have a () after it. I updated the formulas above.