logical test

Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...

My formula in the cell is =IF(C190>=$B$9,$F$9*(D52-$B$9), $F$5*(D52-$D$7)) The Cell output is 8.21 - Which is incorrect. The Logical Test when clicking on function is Logical Test: C190>=$B$9 TRUE Value if True $F$9*(D52-$B$9)= 86.2 Value if False $F$5*(D52-$D$7)=...

I have two forumlas: Formula 1: (ROUND(SUMIFS(G:G,A:A,"*YYY*",C:C,"*P10*")/0.05,0)*0.05) Formula 2: (1/10*(ROUND(SUMIFS(G:G,A:A,("<>*YYY*"),C:C,"*P10*")/0.05,0)*0.05)) I am trying to perform a logical test to check that Formula 1 is equal to 1/10th of Formula 2. I have used the below formula...

Hello--I am new to this board and a bit new to Excel VBA. I am trying to write a script that will do the following--when run, test if the active cell in the current sheet (sheet1) is equal to the active cell in a second sheet (I have named it creatively--sheet2). If yes, then I want it to...

I want to create a formula that will reference a spreadsheet of areas codes and their timezones. If the area code in a cell on the original sheet matches an area code on the reference sheet then in a seperate cell, I want the time zone of the area code displayed.

Just curious if there is a way to reduce the length of my excel formulas that are similar to the following example... =CEILING(IF(((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15>20000,20000,((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15),1000) So in essence is there a way to avoid having to rewrite the...

Hi there, I am at a loss to find the information I need to correctly proceed on a project I am working on. I have created an array formula, which ignores #NA, to get a total for 4 columns... and this works fine. BUT - when I copy/paste the formula to the other 1100 rows, it stays static, and...