Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF condition unable to return a formatted Currency value

Topic Labels: Formulas
Solved
Jump to Solution
1669 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mix_Karmaela
4 - Data Explorer
4 - Data Explorer

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

Capture

Formatting error:
image

Is anyone able to assist with this, thanks in advance.

1 Solution

Accepted Solutions

Just get rid of the final comma and quotation mark, and you should be fine.

See Solution in Thread

3 Replies 3

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.

May have been a typo with placeholders, I’ve edited with actual formula along with screenshots of the value returned.

Just get rid of the final comma and quotation mark, and you should be fine.