excel formula syntax

  1. J

    Need help with formula for macro

    I am working on a macro and need help creating a formula that will check to see if the next row is blank. If the next row is blank, it needs to stop the macro. if tne next row is not blank, I want to run the following formula (using the next cell and so on until it comes to a blank row). This...
  2. E

    How to Calculate and print MAX value from given data (urgent)

    Hello all, I have to calculate the Max utilization of HDD partitions daily on hourly basis, below is the example: <tbody> <tbody> 17:00 </tbody> <tbody> 18:00 </tbody> <tbody> 19:00 </tbody> <tbody> 20:00 </tbody> <tbody> <tbody> 21:00 </tbody> </tbody>...
  3. M

    Deja Vu... Since the release of Office 2013 & Office 365, has there been another Excel Function Dictionary created?

    First and foremost... All credit for these Excel Function Dictionaries/Cheatsheets go to the brilliant <b>Peter Noneley</b>... creator of these magnificent tools... As I hope you all know by now... there exists for each version of Excel... a comprehensive and (very impressive Excel...
  4. J

    average if, multiple conditions... possible?

    First of all thank you in advance. I have learned so much from the answers I've gotten from this board, thank you to all who've responded to my dorky queries here! :) Yet, this one's got me. I have used sumproduct with multiple criteria, and how to use AverageIfs, but I'm hoping to combine...

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