# If / Then Statement - C2 Should Be Equal To S2

Jul 18, 2012If/then statement:

Trying to say if C2 is equal to Fee, Fixed, then C2 should be equal to S2.

Was trying to use

=IF(c2=Fee, Fixed,c2=S2,C2)

but, don't think I have it quite.

If/then statement:

Trying to say if C2 is equal to Fee, Fixed, then C2 should be equal to S2.

Was trying to use

=IF(c2=Fee, Fixed,c2=S2,C2)

but, don't think I have it quite.

ADVERTISEMENT

If A7 is equal to and greater than 95% than B7 is equal to "A". If A7 is equal to 91% but less than 94.99% than B7 is equal to "B"...

View 4 Replies View RelatedI want to create a simple if statement to search if a value in cell B2 is equal to a value in the range 'CodeCheck'!A1:A92

I have written the code =IF(B2='CODECHECK'!A1:A92,"Y","N")

I am always getting N returned even though I am 100% sure the data in B2 is in the 'CODECHECK'!A1:A92 range.

tell me which operator works in VBA the way the OR operator works in functions? I want to write an IF statement that will evaluate whether a variable is equal to any of the three punctuation marks ".", "?", or "!". But I'm not sure how to code it. I attempted the following:

View 2 Replies View RelatedI'm having trouble with a small vba macro. At the end of the macro I test to see if two variables are equal and then print out true or false. However, for some reason even though the variables are equal vba is not treating them that way. I have put the values that represent the variables on a spreadsheet and used the if(x1=x2) formula and it says it is true, also, when I debug the macro and watch the values when it comes to test the logical expression the numbers are the same. I don't understand why vba does not say that the two variables are equal. I have attached a screenshot of the breakpoint where I double check the values are equal.

View 2 Replies View RelatedHow to correct my formula because it does not work?

Here the formula: =COUNTIFS(Data!C2:C24005,A17,Data!M2:M11149,"<=0")

I need to insert the formula in column C (Findings tab) which counts the rows in Column M (tab named "Data") that equal A17 (Column A in "Findings" tab) and which are less or equal zero. In addition if I drag the formula down I want to only the values be entered in highlighted in blue cells in column C (SKUs With Zero Sales in "Findings" tab) and empty cells in not highlighted cells. I attached images of these two tabs: Data and Findings.

I am currently using an Intersect statement in a worksheet module to perform two things:

1. Insert a time stamp into row 2 when row 1 has a price inserted

2.To clear that time stamp if the price is deleted at some later date.

My problem is with the time stamp value being deleted by the user.

If I try to clear the price (now that the time cell =empty) I get a Runtime error 91 - Object Variable or With block variable not set.

I would like to convert this code to a select case statement but I'm not sure how to do this in this situation. Would error coding be appropriate in this instance?

I'm trying to count if there are situations where column a is equal to a specific number and column b is equal to another number.

both columns are numbers. Does anybody have a good idea how to do this, maybe countif, but i am not sure how to do more than one item with that.

I'm trying to set up an if statement that will recognize that if a cell is FHR it will do something...but if it's PHR it will do something else. I think I found the place where I keep getting an error but I'm not sure how to go about fixing the issue.

View 2 Replies View RelatedI am attempting to use a previously Set variable as part of the next Set statement, pretty unsuccessfully at present.

My purpose is trying to look up

Code:

tb_SelJobID.Value

from a userform in Col Z then look across the row to Cols D,I,N,S & W (different types of work) to see if

Code:

TbSelYr.Value

matches the year selected then insert a formula in the row to the left. Then loop down to the FinalRow.

Currently my Set Found1 statement does not recognise my Found10 value. I know it will be my syntax as it always is. I have cut down the following code to display where the problem areas are, Found1 thru 5.

Code:

Sub CmdGo3_Click()

Dim Row As Range

Dim FinalRow As Long

Dim Found1, Found2, Found3, Found4, Found5, Found10 As Range

Application.ScreenUpdating = False

[code]....

Windows 7 with Excel 2010

I have an Excel Sheet which I use as Database. The database has 11 columns and I insert data with the following function:

Code:

Sub testInsert()

Dim adoCommand As New ADODB.Command

Dim sQuery As String

Dim i As Integer

Dim strTest As String

strTest = "test"

[Code] .......

Now I want to retrieve this data. i.e. I want all F1 where F2 and F3 are 0 AND I want them ordered descending. I'm trying to achieve this with:

Code:

Sub testSelect()

Dim adoCommand As New ADODB.Command

Dim sQuery As String

Dim mrs As New ADODB.Recordset

Dim strTest As String

strTest = "test"

[Code] ....

The result I am getting looks like this:

9

8

7

6

5

4

3

2

15

14

13

12

11

10

1

I assume, that the data is interpreted as String instead of an integer. But I explicitely stated the data as Integer when storing the data into the DB.

I have created a very long switch statement, which is too long to be placed in one row in VBA. I have attempted to put a space and underscore at the end of one line and continue the statement on the row below by placing a comma at the start of the second line. VBA will accept my efforts, but when I run the statement in the immediate window, the following error appears.

"Invalid procedure call or argument"

I understand that there are certain rules where I can split a switch statement onto two lines, yet I do not know what they may be.

I am looking to have one formula containing two If Statements that minus.

=IF(B6="investment",C6,0)-IF(B7="gross",C6,0)

So the result of If Statement 1 minus the result of If Statement 2.

What I am seeing at the moment in the cell is FALSE and what I want to see is the sum.

If A1 shows 10:00am and A2 shows 4:00pm, then A3 calculates the total number of hours: =(A2-A1)*24

But if A1 shows "Off," then A3 shows 0: =IF(A1="Off",0,(A2-A1)*24)

Now, if I want to change "(A2-A1)*24" to another if-statement, how do I do this? I can always set up a hidden cell (A4) that contains the results of the first if-statement, and then say: =IF(A1="Off",0,A4). But can I do this without going through all the trouble of setting up hidden cells?

Each row represents a call. If a call in column A equals "CW" and it has the highest duration (H:MM:SS) value in column B, then provide me the date (MM/DD/YYYY) for that call that is stated in column C.

i.e.

Column A --- Column B ---- Column C

AB ------------ 0:02:22 ----- 04/14/2007

CW ----------- 0:03:13 ----- 04/16/2007

CW ----------- 0:01:42 ----- 04/13/2007

Thus, the value that should be returned is "04/16/2007".

I have a problem with a formula inserted with control+shift+enter

The formula is

MEAN(IF(' VALIDATION'!$G$2:$G$59999=D30;'VALIDATION'!$E$2:$E$59999))

In the Validation sheet I have the column G with values 0 and 1, and another column E with numeric values.

Changing the value of cell D30, the formula will calculate the mean of the values in column E that have a value equal to D30 in column G.

The problem is that this function works when D30=1 and not when d30=0, in this case the formula returns N/D.

I have tried using also text values instead of 1 and the formula works . The problem is only when D30 is 0

I am trying to have a cell in sheet "Summary" count the number of cells in column DX of sheet "Analyses" that are greater than 0, provided that the value in column A of "Analyses" corresponds with the value in B8 of sheet "Summary."

(In "Analyses," there are 106 subjects, each taking up 64 rows. So, columns 1-64 correspond to Subject 1, columns 65-128 correspond to subject 2, etc. In column DX, each subject has 64 values that are either 0 or greater than 0. In "Summary," each subject has one row that summarizes the 64 trials. I want a single cell in the "Summary," sheet to reflect the number of times each subject produces a value greater than 0 in column DX of "Analyses.") I tried using this formula, but it did not work correctly:

=COUNTIF(IF(Analyses!$A$1:$A$10000=Summary!B8,Analyses!$DX$1:$DX$10000,""),">0")

(Summary!B8 = 1, so I am trying to calculate the number of values in DX that are greater than 0 only for subject 1.) When I press enter, this yields a value of 384. This is impossible, given that subject 1 only has 64 possibilities of yielding a value greater than 0. Subject 1 has 2 values in column DX that are greater than 0. I tried making this an array formula by pressing Shift+Ctrl+Enter, and that just gives me a #VALUE! error.

I have a quite complex list of variables to put into a formula to come up with the correct number and I need some help to figure this one out. I don't know if it would be easier to set up a chart and then index the chart to do a lookup or how I need to go about doing this to achieve the most efficent solution.

I need the following to go into one formula:

1. =< 24 needs to show the number 24

2. =< 30 but > 24 needs to show 30

3. =< 32 but > 30 needs to show 32

4. =< 36 but > 32 needs to show 36

5. =< 40 but > 36 needs to show 40

6. =< 48 but > 40 needs to show 48

7. =< 50 but > 48 needs to show 50

8. =< 60 but > 50 needs to show 60

9. => 60 needs to show 60

I am trying to set up a spread sheet to figure square footage of plastic laminate countertops, but the plastic laminate only comes in several stock sizes : 3x8, 4x8, 5x8

3x10, 4x10, 5x10

3x12, 4x12, 5x12

So if I have a countertop that is 25 sq ft., I cant use a 3x8 (24 sq. ft), so I need to go up to the next size which would be a 4 x 8.

I might need to use a ROUNDUP function with this formula too? I already have cells set up to figure the depth, backsplash height, and front edge height and then give me the squage footage of that.

Example If Selection.Value *Does not equal* ActiveCell.Offset (0,1) Then .....

View 1 Replies View RelatedI am trying to set a scorecard up where it will give points depending on the % actual. For example:

if less than 60%, then 0,

if equal to or greater than 60% but less than 75%, then 1

if equal to greater than 75% but less than 80%, then 2 and so on.

I have been playing around with the example below, but can't seem to get it working.

[php]=IF(A1<60%,0,IF(A1>A1<75%,1,))[php]

Maybe it 's because I pickled my brains last night.

revised this code to reflect the "not equal to". I want the user to only enter "In" or "Out." Therefore, If cells b19:B26 does not have either word, then the message box will prompt the user to enter the correct word again. I think my code needs to be revised into some kind of loop.

View 9 Replies View RelatedI've created the following function that chooses the maximum value from a set of cells then inserts theappropriate row number (within a table) into a new cell.

=IF(J27=0,"?",IF(J27=J19,1,IF(J27=J20,2,IF(J27=J21,3,IF(J27=J22,4,IF(J27=J23,5,IF(J27=J24,6,IF(J27=J 25,7,IF(J27=J26,8)))))))))

It's working fine until I have 2 cells with the highest value. The above statement is entering the first cell that meets the criteria in the new cell but ignores the fact there maybe 2 (or more) of the same value.

How can I get both (or all) to be entered in the same cell? Is there a better way, maybe highlighting all the rows in the table that equal the max figure?

I am confusing of using the equal function in vba, I need to have some cells between sheet1 and sheet to be equal but i cannot just put = sign in the sheet as it may be deleted. Can I have it as VBA code? how to do that and where to put this code, in what event?

View 3 Replies View RelatedI have 31 cells in a row (one for each day of the month. we collect data in these cells by typing "y" or "N". based on these input, cell 32 calculates the percentages based on total of Y's. Cell 33 has goal percentage. So, if the goal percentage is 30, Is there a way when a "y" or "n" is entered in cell 25, if the data percentage is = or 5% above the goal to get text message saying "good" but if the data percentage is 5% or more below goal, get a "not good" message?

View 3 Replies View RelatedI am having trouble creating a formula that will do what I need it to do. In C4 the I already have a formula that states if B4 is greater than 94.99% then it will equal 5. What I need it to do is if it is equal to or greater than 95% then =5. Also if it is equal to or less than 94.99% - 92% =3 and if less than 91.9% =1. Here is the worksheet I am using....

View 15 Replies View RelatedI have a formula that I am trying to get the IFERROR to equal blank.

So if it's an error, I just want the cell to be blank.

[Code] .....

How to recreate the formulas used in my old database. One important factor is that:

In the old database, once you type in a word, it associates it to a number, and also adds that number in a further row. how do i do this?.

EXAMPLE:

- i have the word "sitter" that = 10.25$. If i enter "sitter" in column F, it enters 10.25$ in column M.

- Likewise, i can also have the word "private" that = 13.50$. If i enter "private" in column F, it enters 13.50$ in column M.

Is it possible to do an IF formula based around a value it does not equal?

eg I have one column, that is perforning a SUMIF providing that a certain cell is equal to a particular constant.

=IF([cell]=[value],SUMIF([range],[criteria],[sum_range]))

In the next column I want to do it the other way round so that:

=IF([cell] DOESNOT=[value],SUMIF([range],[criteria],[sum_range]))

Is it just a simple symbol??

I have a cell, M87. The score in M87 can be less than 13 or greater than 25. I need a formula within M94 which refers to M87, and outputs depending on the the following criteria. If M87 is less than 13 then output as D. If M87 is 14, 15, 16, or 17 then output as C. If M87 is 18, 19, 20, 21, 22, 23 or 24 then output as B. If M87 is greater than 24 then output as A.

View 3 Replies View RelatedIs there any way to make one cell on a separate sheet appear EXACTLY the same, including formatting and values?

As in this for example:

Pieces of Paper (Blue)

I would like to keep the formatting for (Blue) , color and bold, but I have not figured out how to do this.

Copyrights 2005-15 www.BigResource.com, All rights reserved