percantage

  1. M

    TEXTJOIN with IF conditions, but not showing correct format?

    Hello, So I am trying to use the formula to join all of the data from 1 sheet into a cell if there are multiple rows with the same data on. It work's for the most part, however the date I want to join together are all percentages, and it keeps joining the data not in a percentage format... Is...
  2. J

    Excel Problem regarding Formula

    Hi I am trying to write the below in a formula but I am having some problems, I tried to a formula but is not working. You write amount (and on which category the amount fall it will work the sum) If amount is between 0.00 to 9100.00 = 0% - 0.00 If amount is between 9101.00 to 14500.00 = 15% -...
  3. B

    Sumif for a certain format

    How do I add up values in a particular format and ignore values in other format. So say I have a row with values of dollars($) and sterling(£) but I only want to know the total of the dollars at the bottom of the row and ignore the sterling (£). Also say I have a row with percentages(%) and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top