EV_TRAINING - profile

EV_TRAINING · Jul 29, 2022

I’m trying to write a formula that says. If {Inspection Date} is not blank and the number is greater than 730, then “No” or If {Inspection Date} is not blank and less than 730 then “Yes”. I keep getting hung up with the blank fields. This is my curr...

EV_TRAINING · Jul 29, 2022

Ben.Young: IF( AND( {Inspection Date}, {Number} ), IF( {Number} > 730, "No", IF( {Number} < 730, "Yes" ) ) ) YES!! This is exactly what I needed. I was ov...

User Statistics

User Activity

IF, Then formula

Re: IF, Then formula