ands

  1. E

    If Formula is less than X show Y in Same Cell

    If I have a formula such as, =B8*0.09 and I want any answer that is under 5.00 to show 5.00 and any answer above 5.00 to show the exact answer to the formula. Is that possible to do in the same cell? If so, what would that formula look like? Thanks!
  2. J

    Mulitple OR's using IF's?

    I have a problem that is driving me crazy. I have data coming to a cell, it will be between 0.00% and 0.50% I want to have a weighted percentage using this data. So if Cell E39 is 0.00% I want E40 to read 0% but if it E39 is 0.01% to 0.10% I want it to read (-10%) 0.011% to 0.20% reads...

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