I have a value in a cell, I would like to display the value directly with a
text modifier if it is above a certain threshold or display a scaled value
with a different text modifier if it is below a threshold. I use the value
in a different calculation so I don't want to change the value of the cell,
only the way it displays.

Examples:
If the value is time:
..5 should read as "4 hours" while 2 should read as "2 days"

If it was money:
..5 should read as "50 cents" while 2 should read as "2 dollars"

Thanks.