Forum Discussion
Solved
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...
=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”)
=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”)
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.
- my apologies, in each case TODAY must have a () after it. I updated the formulas above.
- That is FANTASTIC!!! Thank you so much