Hi Mkosek,

Is your Percent Complete field at Text field with a fixed set of values like 25, 50, 75? Or is it a numeric field that you are calculating against? If you are trying to calculate against a numeric lookup you would want something like

If([Percent Complete]>=75, image,

If([Percent Complete]>=50, image,

If([Percent Complete]>=25, image,

image)))

If it is a text field type then you would want to construct it as

If([Percent Complete]="75", image,

If([Percent Complete]="50", image,

If([Percent Complete]="25", image,

image)))

That would at least be your basic starter If statement for structure of this formula that you could then customize to fit your specific images and needs. I hope these examples are helpful.