follows;

  1. J

    Formula Help - If Cell Falls Within Certain Range

    Hi! So sorry if a question like this has been posed before, I'm sure it will have been covered at some stage .. I'm looking to create a formula within a work spreadsheet as follows; If the value of a cell is lower than 5 then new cell is A, if it is between 5 and 9.9 then B, if it is between 10...
  2. A

    Nested IF AND

    Hi I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows; <tbody> A B 1 2500 Yes 2 2500 No 3 1200 Yes 4 1200 No 5 1900 Yes 6 1900 No </tbody> The...

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