obvious

Hello Clever People, I have another query for you that is probably so obvious you'll have me as a fool. Anyway, onto my "problem". I'd like to create a formula to enable me to convert units of time to hours and minutes. The units of time are blocks of 6 minutes. So 10 blocks = 1 hr (or) 60...

Hi, I cannot for the life of me figure out what I need to do to stop this from happening. I am working to edit some VBA that a colleague has created. There is a simple error in a line where the current text is .row 1 This needs to be +1, but everytime I type +1, it autocorrects it to the...

The green section of my formula is counting blanks as Tier 4 and some below the mark of Tier 1 are showing Tier 4. Can anyone see an obvious error i may be missing? =IF(AND($D5>=$N$6,$E5>=$N$7,$F5>=$N$8,$G8>=$N$9),"Tier 4",IF(AND($D5>=$M$6,$E5>=$M$7,$F5>=$M$8,$G5>=$M$9),"Tier...

Hello I have a dataset and I am trying to use a formula. However despite spening ages on it it still not working. I am new to this and am probably missing something pretty obvious, and I was wondering if someone could have a look at it to see if it is written incorrectly. =-1.675 + (0.037*e2)...

I hope it is abundantly obvious what I'm trying to do cubevalue("ThisWorkbookDataModel",[Measures].[sumAmt], CUBESET("ThisWorkbookDataModel"," Filter(...

Hello, it will be a stupid question most probably... Why in VBA we are using the following: "If Not Selection.Value > "" If I'm correct that this basically means "if selection value is not bigger than nothing", which mean if value is 0.. There is no "If Selection.Value = "" for this or why...