Help

IF condition unable to return a formatted Currency value

Topic Labels: Formulas
Solved
Jump to Solution
1483 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.