IF condition unable to return a formatted Currency value

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.

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.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.