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.
Best answer by ScottWorld
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.
+35That 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.
+35May 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.