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.
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.