I really enjoy Airtable. Although, I am having a terrible time with formulas in general even though I have looked at the resources online.
In this scenario I have been trying to expand upon the equation in the screen shot. If the value returned is 1 thru 3 I would like to show the number the equation in the image returns plus “.” If the value shows 0 or a negative number I would like it to show the returned value plus “” If the Value shows 4 thru 7 I would like it to show the returned value plus “” Lastly if the value shows 8 or greater I would like it to show the returned value plus “”
Examples of what I would like to see in my cells are:
Can anyone help with this? I have made multiple attempts but they have all failed. I think I must be making small errors. A misplaced comma or parentheses. Thank you in advance for anyone who can take a crack at it!!