$12

Hello -looking for some help. Thanks in advance! A1 = $12.55 B1 - If A1 has any cents (.01 - .99), show that full # or $12.55. If there are no cents (i.e. 12.00), then show only the $, not the cents or $12 Example 1 A1 = $12.55 B1 = $12.55 Example 2 A1 = $12.00 B1 = $12

Hello All, I am having a bit of an issue putting together some DAX Formulae; this is something I can do in Excel but using Power Pivot and Power Query I am out of my comfort zone! There are three columns in CAPS that I am trying to figure out in Power Pivot. MIN TIME - this is using 'Time'...

Hi - I am trying to create a formula to determine revenue share for a company I work with. The initial revenue share percentage is 5%. On a yearly basis, Company X will receive 5% of Company Y's revenue until a $12 million cumulative number is hit. Once $12 million is hit, the revenue share %...

Hi I have the below table: <tbody> OrderID Price 1 $18 1 $18 1 $18 2 $16 3 $20 4 $12 4 $12 4 $12 </tbody> Now, I want to merge values in the column Price for duplicate values in Order ID, like below: <tbody> OrderID Price 1 $18 1 1 2 $16 3 $20 4 $12 4 4...