platinum

  1. C

    Hiding/Unhiding a row in a Password Protected Spreadsheet

    Hi Everyone, I am trying to find out if it is possible to hide/unhide a row on a password protected spreadsheet when the data changes in a cell? I have a Spreadsheet that contains a lot of formulae. In order to prevent people messing with the formulae either inadvertently or maliciously I have...
  2. C

    #VALUE! Displaying instead of " "

    Good Afternoon All, I wonder if someone could point me in the right direction with a formula that returns #VALUE! when the formula is not True. The formula I have is: =IF(day(B71)=3,"Queen's Platinum Jubilee",""). So when B71 doesn't equal 3, I'd rather display a blank cell rather than the...
  3. D

    Showing a word based on results

    I feel a bit blonde posting this. But I need an if statement and can't quite get it right. I want it to calculate a percentage then show a word based on the result. So there will be 4 words. If a2 is less than 90% of a1 then the word will show "Bronze" if a2 is 90-90% of a1 then the word will...

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