Hello. I am trying to write an “IF” statement that has multiple parts and coming up short.
The 2 conditions are:
if cell K13 is blank AND cell J13 is less than cell O2, then they should use the DAYS formula to count the difference between and add text [=DAYS(O2,J13)&” days”] and if both conditions are not met, then the field value should be “N/A”.
I can’t figure this out.