This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Help with IF percentage formula for negative value...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

0
2752
14

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 02:06 PM

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!

14 Replies 14

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 05:25 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 06:17 PM

Check out the following base

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 08:08 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 09:10 PM

@CottageKeeper

Sorry Lisa,

Following link will get you as editor in the base .

Please let me know if you encounter any problems.

Thanks,

Neal

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 02, 2019 09:14 PM

@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.

Thanks,

Neal

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 14, 2019 11:17 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 14, 2019 12:32 PM

I have set you up as creator.

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

Neal

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 14, 2019 01:43 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 14, 2019 02:06 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 14, 2019 02:58 PM

I have created field called “Lisa” and it uses single formula instead of using multiple formulas.It will help you to use formula without need of understanding dependent formulas.

Name of field I am using is called “decimal”. You need to replace “decimal” with your fieldname in your base.

Neal

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 15, 2019 07:05 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 15, 2019 08:39 AM

Formula expects field to be Decimal instead of currency.

At present your SAL is of type currency. Change its formatting to be Decimal.

i.e. Customize field SAL formatting to be

Decimal(1.0) with precision 1.00

Neal

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 15, 2019 01:03 PM

Thanks, Neal, unfortunately, that is not an option. I have to keep the SAL field as a dollar amount.

This is what I was able to do as a workaround. I can’t have the emoticon face populate for negative numbers in the SAL field - which what I was looking for. But until there is a better solution, I’ll have to stick with this:

I am grateful for your support in all of this!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Aug 15, 2019 02:03 PM

Try the following

- Create field SALCOPY of type formula. Formula will be SAL% and format it as decimal with precision 1.00
- Create field SalEmoji and its formula will be the formula with emoji but use fieldname SALCOPY in that formula
- SALEmoji field will have data as per your need.
- SALCOPY can be hidden afterwards.

Neal