Re: If formula syntax for if field is blank

Try this in a new formula to test.

If([Moisture Content]>=[Abrasive - Moisture threshold of Current Incoming inspection],
   "<div style=\"color:white; background-color:#FF0000;\"> The sample is out of spec! It should be < "
 & ToText([Abrasive - Moisture threshold of Current Incoming inspection]*100) & "%" & "</div>",

[Moisture Content]<[Abrasive - Moisture threshold of Current Incoming inspection],
  "Sample is within the acceptable range of <" &[Abrasive - Moisture threshold of Current Incoming inspection]*100 &"%",

"The acceptable range is <" &[Abrasive - Moisture threshold of Current Incoming inspection]*100 &"%")


..... as for the null issue, I believe that Excel always treats a blank cell as a zero if you are doing mathematical operations but in Quickbase you get to choose whether a blank in a data entry numeric field means zero or a blank means null. 

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------