Help with IF percentage formula for negative values

[CottageKeeper]

Hello AT Community

I’ve got a formula partially working but I’m having some difficulty tweaking it to just the right look.

Looking for numbers in the SAL field that result as a negative to show the emoji - so far so good. How do I make positive numbers in the ‘test’ field show as a percentage with only two numbers behind the decimal and with proper rounding up?

Thanks in advance for your brilliance!

[nea_lpatil]

@CottageKeeper

You can click formatting tab as in the following

It might not be possible the way I recommended because for formatting to work the result of formula should be number. In your case result is emoji or number.

Neal

[nea_lpatil]

@CottageKeeper

Check out the following base

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

It manipulates decimal number before and after decimal point.
Please note that this is initial version .
You need to check and modify formulas so that it works for all the possible numbers in your base.

• Copy base
• check formulas
• Build formulas for your base
• Test it
• Let me know if you need help

Neal

[CottageKeeper]

Thanks so much Neal, I don’t see where I can copy the base. I don’t get the formatting option because of the formula. I think the base was shared as view only, as I can’t see any of the formulas or copy. Appreciate your help.

[nea_lpatil]

@CottageKeeper
Sorry Lisa,

Following link will get you as editor in the base .

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Please let me know if you encounter any problems.

Thanks,
Neal

[nea_lpatil]

@CottageKeeper
Lisa,
I was also able to change permission to you as editor.
No need to click above link to the base.
You are all set and you should be able to have copy base link as well as you should be able to see formulas.

Other users can click the following link to base and they will get editor access.
It will also have copy-base link to copy base.

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Thanks,
Neal

[CottageKeeper]

Thanks so much Neal, unfortunately when I click the formula, formula 2, formula 3, field 8, and field 9 I can’t see the customize field type option which would show me the formula you made. Would it be possible to change my permission to ‘creator’ so I can see the formula when I select the dropdown for each of these fields in the customize field type option?

[nea_lpatil]

@CottageKeeper

I have set you up as creator.

Other alternative for looking at formulas is to copy/duplicate base .

Neal

[CottageKeeper]

Thanks Neal, for some reason I didn’t have the option to copy/duplicate the base, not sure why? I’ll look again, grateful for your help!

[CottageKeeper]

Neal, you’re amazing! I have reviewed and but unfortunately, I’m still confused. I looked at my initial post and adjusted the wording I’m hoping it makes better sense?