
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2020 07:56 AM
Hey guys,
I’m struggling to get my if condition to return a value which is formatted as a currency.
Formula as below
IF(Client=‘Ebay’,{Qty/Hr}*{Qty/Hr Price}*0.029+0.30,’’)
This is returning the value as a number with decimals, but refusing to allow me to format as currency
Formatting error:
Is anyone able to assist with this, thanks in advance.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2020 08:55 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2020 08:09 AM
That is not a valid formula. What exactly are you trying to do? Please post some screenshots of your system, along with an explanation of what you’re trying to do.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2020 08:47 AM
May have been a typo with placeholders, I’ve edited with actual formula along with screenshots of the value returned.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 23, 2020 08:55 AM
Just get rid of the final comma and quotation mark, and you should be fine.
