IF condition unable to return a formatted Currency value

[Mix_Karmaela]

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.

[ScottWorld]

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.

[Mix_Karmaela]

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

[ScottWorld · Accepted solution]

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