and yet again E-I is returned (and I tried ="",NULL and =NULL,"" but they also didn't work and tried inserting it before the final E-I part and still not working).
So I'm down to three options,
Option 1, someone here sees what is wrong with the formula that I'm missing.
Option 2, I extend out the IF Then statements to include all those in E, F, G, H and I then leave a blank.
Option 3 (easiest) I simply leave the column blank and do the formula in excel.
Anyone see why my formula is failing when severity is blank?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Re: Trouble with If then to return blank in Access
Interesting, I wondered if it could be consolidated like that in Access but never tried it. I'll give it a try. I also didn't try =TRUE,NULL, I'll give that a try too.
thanks.
Bookmarks