IF Formula returning as Unparseable
Good afternoon everyone,
I am having a heck of a time trying to figure out why my formula keeps returning as #unparseable.
If a Category says Expedite, the cell needs to show $25.00, if not, it needs to show $0.00. My formula isΒ =IF(Category1 "Expedite", $25.00, $0.00).Β
I've tried removing the dollar signs, the decimals, and I can't get it to work for me. What am I missing here?
Β
Comments
-
Try
=IF(Category@row = "Expedite", 25, 0)
-
Hi JessB,
Β
=IF(Category1 "Expedite", $25.00, $0.00). is your original formula, and it looks like you're missing the first punctuation after Category1, and you'll want to put quotation marks around the values to input into your sheet.
Β
I think you'll want to do this:
Β
=IF(Category1 = "Expedite", "$25.00", "$0.00")
Β
I tested this out and it works in my sheet.
Β
However, if you find that the above formula does not work, I found that copying and pasting it from this Community post gives you the #unparseable error.Β
Β
As a result, please try typing out exactly what I've typed above instead of copying and pasting it to see if this helps.
Β
You can also use what nlarsen suggested by substituting Category1 for Category@row.
Β
Alison
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives