Skip to main content
Question

icon formula for currency

i am trying to create an icon that will display when the [price] is equal to 0.

I tried an If statement and a Case statement and i am getting compatibility errors. What to i start the formula out with for currency type field? do i need to convert it to numeric first?

    This topic has been closed for replies.

    There is a list of icons you can use here.

    https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160



    You can make a formula Rich text field like this

    IF([Price]=0, "<img src=https://images.quickbase.com/si/24/204-warning.png>")
    Terms & ConditionsAccessibility statement