IFERROR with icon set or alternative text.

[tails1]

Hi, I'm building an inventory/stock tracker, I want rows to highlight when the product needs reordering. I've taken this iferror formula from one of Microsoft's templates, the file named Inventory.
The formula is the following =IFERROR(([@[Quantity in Stock]]<=[@[Reorder Level]])*([@[Discontinued?]]="")*@valHighlight,0) I don't need the discontinued part.

I've wrote the following formula in the file named INV Tracker =IFERROR([@[Closing stock]]<=[@[Reorder level]],)

I would like to change the TRUE/FALSE to use an icon set but I'm struggling. What do I put after the comma to return a 1 or 0 rather than TRUE/FALSE?

If more information is required let me know.

Thanks
Andy

[Fluff13]

How about

Please Login or Register  to view this content.

[tails1]

Thanks Fluff13, don't think I'd have figured this out on my own. Is there a name to this double negative formula?

[Fluff13]

The -- is often called a double unary & is used to coerce true & false values into 1s & 0s