IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible.
=IFERROR(("Save " + (ROUND(1 - ([Sale Price]102 / [Retail Price]102), 2) * 100) + "%"), "")
The formula is working in giving the accurate savings while also showing a result that populates it to read easily with the word "Save __%". With the IFERROR it's also blanking the cell if there's no data in the two columns. The one result that is bugging me is that items that are not on sale say "Save 100%) because there's no value in the sale price column for the formula to use.
Is there a way to blank the column if the result is "Save 100%"?
Comments
-
Hi Nick,
You might try adding an IF statement to your function that will return blank if the sale price is blank. For example:
=IFERROR(IF(ISBLANK([Sale Price]1), "", ("Save " + (ROUND(1 - ([Sale Price]102 / [Retail Price]102), 2) * 100) + "%"), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!