Would it be possible to create a formula that would display a figure in dollars unless it fell below a dollar, then it would multiply it by 100 and display it in cents?
I know how to create a custom data format that uses the cent symbol. But any formula to automatically multiple the number if below a dollar and change the data type is beyond me.
Hi there!
If you’re purely trying to solve for how it looks, and don’t expect to be able to calculate off of the results, here’s how you can do it:
Hope this helps!
Hi there!
If you’re purely trying to solve for how it looks, and don’t expect to be able to calculate off of the results, here’s how you can do it:
Hope this helps!
Here is a custom format that does what you are asking, including the multiplication by 100. The value in the cell is unchanged, unlike with a formula. 1.25 will display as $1.25 and 0.35 will display as 0.35¢. You can see some examples in the screenshot.
If it is possible, it will be done by changing the manner is which the value is displayed, and will not require multiplication by 100.
Multiplication by 100 changes the value in the cell, which will change the result in any further calculation depending on the value in that cell.
Regards,
Barry
Badunit wrote:
"1.25 will display as $1.25 and 0.35 will display as 0.35¢."
Misleading at best. 0.35 is $0.35 or 35¢. 0.35¢ is a little more than one third of a penny.
That said, this looks like an editing error in the text, as the examples in the screen shot show standard formats for all four examples.
Regards,
Barry
🙄
Editing error too late at night. The screenshot has it correct.
"Editing error too late at night."
Been there. Done that. ☺️
Cents or dollars - formula
