I’m trying to replicate some spreadsheet conditional formatting for some data that I require publishing with some specific rules around precision - I can’t seem to replicate this using the functions that are available in Airtable (or so I think).
Has anyone found a way to display numbers in formats like this:
If < 1, then 2 decimal places.
If < 10, then 1 decimal place,
If >= 10, then 0 decimal places.
So in theory I would get the following numbers:
0.1623 -> 0.16
0.2688 -> 0.27
1.2344 -> 1.2
3.3759 -> 3.4
12.6984 -> 13
I have tried using ROUND(Value,if(value<10,1,0))
But as this ultimately depends on the precision setting this doesn’t display what I need.
Is there a way to recreate an excel function;
Any tips would be appreciated!