Percentage in a formula
Hi,
Happy New Year!
I got stuck with what I thought was a simple formula and I'm hoping you can help me.
We have three different thresholds that I need to use to change the RYG balls:
Above 3% - Red
Between 0 and 3% - Yellow
Below 0% - Green
My formula looks as below:
=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.3, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))
It does not work with "Red" at all. I only see yellow and green balls.
Can you help please?
Best Answer
-
3% is .03. Try changing your formula to
=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.03, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))
Cheers,
John
Answers
-
3% is .03. Try changing your formula to
=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.03, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))
Cheers,
John
-
Thank you, it worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 153 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…
- Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Week…