This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
