equal

I am needing three formulas to help counting dates <colgroup><col width="760" style="width: 570pt; mso-width-source: userset; mso-width-alt: 27794;"> <col width="360" style="width: 270pt;"> <tbody> The number of dates / rows shrinks and grows daily and there is a lot of other information...

is there a faster way besides using conditional formatting to color specific columns like in VBA. I want to have the cells for example in C4-C53 g4-g53 k4-k53 etc etc to change colors if they are less than or equal to 1. i have 40+ columns to do so as you can see doing it in conditional...

Hello, I'm looking for formula that look at value in A3 and if that value is a whole number OR equal to value in A1 OR equal to value in A2, TRUE; otherwise FALSE. Thanks!

I have a spread sheet that i am needing a formula in cell "AE3" in it that executes the following: Take the first 3 letters of the value of cell "M3" and if those first three letters equal RUP then populate AE3 with "Run Unit Price".....but if the first three letters in M3 equal CTP then...

I want a message to pop up if the value on any cell in of a range of cells is equal to 'False" at the moment I only can run it if one cell is equal to false. but I want to add the condition so it includes if any cell in a range (A:1 to A:10) is equal to 'false' Private Sub...

this is the excel forumla which i used to calculate count of values which are less than and equal to E2 =COUNTIF(Sheet1!D2:D13,"<="&E2) but i want this same thing to be used in vba so i used this function Application.WorksheetFunction.CountIf(rng, Range("<=" & "E2")) but it showing error of...

Anyone know if it's possible to set a userform caption to equal the contents of a cell? Thanks

I need two formulas that read the values in column D compareit to column G and H. Based on the outcome column I would say “100% Met” or “50%Met” or “Not Met”. First Formula Rules: To achieve "100 % Met" the values in column D haveto be greater than or equal to the values in columns G To...

Hi all, I'm really confused by an issue i'm facing with 2 simple conditional format rules on a single cell (H6): Cell Value - Equal to - =0 - Green fill Cell Value - Not Equal to - =0 - Red fill When I apply these to H6, the cell is always Red regardless of value, even if I delete the not...

Hello I have this very simple formula: =AA938/L938. I wish to add 200 to this (AA938/L938+200) only if another cell (H938) is greater or equal with 5200. (H938>=5200). Thank you very much!

In a workbook I am creating, I check to see if the user input all of the information they were supposed to. One way it does this is the look at the value in a cell that has a SUM formula in it, and compares it to some other cells where the user broke down each individual amount. (The amounts...

Can somebody help me?: I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1)) But, only if AB946 is greater or equal to 5200, I wish the result to be increased with 100 (+100). Thank U very much!

Hi All, I'm referencing a cell on another tab by typing in the equal sign and then navigating to the referenced cell and clicking on it. The cell that I'm referencing has general number formatting but contains text. The cell that I have made equal to that text cell is showing a zero and not the...

Quick question because my mind is blanking- I have a macro that I'd like to have run if the value of Cell "A1" does not equal the value of Cell "B1". I'd like to insert the piece of code in the front part of the macro. If A1 does equal B1, a msgbox opens that says "hello". p.s. Sheet is named...

Hi, I need a formula to cell K3 to equal n3 from sheet with name 60001 cell k4 to equal n3 from sheet with name 60002 cell K5 to equal n3 from sheet with name 60003 and so on. or in another words if i drag down the formula it will change the sheet number and increase it by 1, without changing...

I need help creating a formula that will count two cells if they meet a criteria and have those two cells equal "1", not "1"per cell, 1 for both of the cells. and then equal zero if the criteria is not met. i am building a spread sheet that has 7 columns (one for each day of the week) then has a...

sort out possible patterns are three = major, minor and equal detect the three colors in the corresponding color, save in the flat, please http://www.mediafire.com/file/j12ffe8e3c1e8wu/3_padroes_lotofacil.xlsx/file

Hi, I need to average the first n (let's say 3) numbers in a column, from the first one that is not equal to zero. For example: <tbody> 1 5 2 2 5 2 2 5 3 2 0 3 0 0 3 </tbody> In the left column, checking from down up, first there is a zero, and the average of the following 3 numbers...

I have a formula in a cell and then I'm pivot tabling off those cells. The pivot table is not calculating the formula count of what is equal to 1, instead its count anything with text in the field all rows. I need it to count only what is equal to 1 in the cell in that pivot table.

Looks like the range.replace method has a findvalue and a replacevalue, is there a way to replace all values in a range which are not equal to 'alpha' for example ? already have code to iterate each cell. hoping for something more awe-inspiring :) thank you!